Easy way to strip time part in sql date time

8 Kicks

submitted by kcherupa(295) 2 years, 8 months ago

This explains the easy way to strip time part in sql date time

3 comments |category: Database |Views: 289
Tweet

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

Comments:

posted by lysp(5) 2 years, 7 months ago 0

or:

SELECT DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)

posted by jamiegs(0) 2 years, 7 months ago 0

CAST(FLOOR( CAST( GETDATE() AS FLOAT ) ) AS DATETIME) is another way to do it.

What's this?