You are currently browsing the category archive for the ‘SQL’ category.

Quite often during data conversion processes, I am required to get only the date part from a datetime or a timestamp value. Here is a trick that does not involve CASTing and is quick to respond:

DATEADD(DAY, 0, DATEDIFF(DAY, 0, <ColumnName>))

Here is how it works: Whether smalldatetime or datetime, DATEDIFF(DAY, 0 returns the number of days since the base date, and DATEADD(DAY, 0 returns the integer as a date value.

Neat, isn’t it ?

Timeline

August 2017
M T W T F S S
« Mar    
 123456
78910111213
14151617181920
21222324252627
28293031  

Blog Stats

  • 42,577 hits