Post reply

How to remove minutes and seconds from DateTime?

  • March 28, 2012 at 10:50 pm

    #1466157

    dwain.c (3/28/2012)

    Lynn - Looks like the third (hidden) line on my last post!

    Yep, missed it.

  • December 29, 2015 at 1:35 pm

    #1848623

    This worked for me just great

    thanks

  • December 29, 2015 at 1:56 pm

    #1848626

    Got a bit messier than I was hoping for:

    SELECT DATEADD(Hour, DATEPART(hour, GETDATE()), CAST(CAST(GETDATE() AS DATE) AS DATETIME))


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • December 29, 2015 at 10:07 pm

    #1848680

    Try this

    select dateadd(minute, datediff(minute, 0, yourcolumn), 0) from yourtable

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply