Easy way to strip time part in sql date time

8 Kicks

Kick It.

Drop Kick

published 4 months, 11 days ago, submitted by kcherupa(255) 4 months, 15 days ago

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

3 comments | category: Database | Views: 287

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(0) 4 months, 11 days ago

or:

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

posted by jamiegs(0) 4 months, 2 days ago

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