Post reply

Date conversion

  • September 18, 2009 at 1:30 am

    #226302

    Hi,

    I need to change the format of a date from '2009-09-18 12:54:59.860'

    to '2009-09-18 00:00:00.000' (i.e. I want to keep the time format but with 00 values). I need to do it through SQL only.

    How is it possible?

    Thanks in advance.

  • September 18, 2009 at 3:09 am

    #1055433

    The solution is here

    This thread should be closed!

    ➡

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • September 18, 2009 at 3:36 am

    #1055450

    Dugi (9/18/2009)

    The solution is here

    This thread should be closed!

    ➡

    Hi Dugi,

    its a server error, thats why posted twice. Anyway got the solution, thanks.

  • September 18, 2009 at 3:38 am

    #1055452

    NO problem just to avoid the double discussions!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Viewing 4 posts - 1 through 4 (of 4 total)

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