Post reply

Date format in debugger

  • June 23, 2005 at 11:32 am

    #89628

    What's the secret formula for entering dates (datetime datatype) in the debugger.

    I know I've seen it posted here before but I just don't remember and I can't get it to work.

    TIA - ron

  • June 23, 2005 at 11:40 am

    #568022

    Just found the answer in another thread this format will work:

    2005-03-31 (no quotes)

     

     

  • June 23, 2005 at 11:48 am

    #568029

    Shhht, it's a secret .

  • June 23, 2005 at 2:29 pm

    #568116

    I think this it is a secret.  I couldn't find it in BOL or the knowledge base.  I'm sure its there somewhere but I couldn't find it.

  • June 23, 2005 at 2:30 pm

    #568118

    Was in your head... maybe we should document it .

  • June 23, 2005 at 2:34 pm

    #568122

    Agreed!

     


    * Noel

  • June 23, 2005 at 2:49 pm

    #568131

    The format YYYYMMDD hh:mm:ss (no quotes) is the iso standard for dates. Frank posted a great link for information on dates. But I did not find it (must be located next to the information in bol)

    Mike

Viewing 7 posts - 1 through 6 (of 6 total)

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