Easy way to strip time part in sql date time (cherupally.blogspot.com)

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

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

3 comments | category: | Views: 287

tags: another

new 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:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:

Comments:

posted by lysplysp(0) 4 months, 11 days ago

or:

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

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

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

information Login or create an account to comment on this story