1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How to return the date part only from a sql server datetime datatype?

Question Posted / nishi jain


How to return the date part only from a sql server datetime datatype?..

Answer / Navin Gupta

To return only the date part of a DateTime data type in SQL Server, you can use the DATE function:n`SELECT DATE(YourDateTimeColumn);`

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

which table keeps the locking information? : Sql server administration

1 Answers  

How to populate a table in sql server?

1 Answers  

Explain how to integrate the ssrs reports in application?

1 Answers  

What is order of B+tree?

1 Answers   HCL,

What is the difference between varchar and nvarchar datatypes?

1 Answers  

What is difference between Triggers and store procedure?

2 Answers  

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers   HCL,

Explain optimistic and pessimistic concurrency?

1 Answers  

What are views used for?

1 Answers  

What is a schema in ms sql server 2005?

1 Answers  

What is sql server 2000 work load governor?

1 Answers  

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1 Answers  

For more SQL Server Interview Questions Click Here
Categories