Post reply

Dumb Question...but I'm stuck!!!

  • June 5, 2003 at 3:45 pm

    #160242

    In my query, I just want to know how to format my date fields so that only the date is displayed, without the time.

    For example, my statement looks like this...

    SELECT a.DBR_DATE

    FROM MDRECHDR

    --------------------------------------------

    It will produce a result that looks like this...

    DBR_DATE

    -----------

    2002-06-29 00:00:00.000

    I want it to look like this...

    06/29/2002

    Any suggestions???

  • June 5, 2003 at 3:50 pm

    #460062

    SELECT CONVERT(VARCHAR(10),a.DBR_DATE,101)

    FROM MDRECHDR

  • June 5, 2003 at 3:59 pm

    #460063

    Thanks a lot...that came right through!!!

  • June 5, 2003 at 4:13 pm

    #460064

    An after thought read about convert in BOL 2000, you'll most likely going to need it again.

  • June 5, 2003 at 4:20 pm

    #460067

    what is BOL 2000? I can't believe that I brain farted on the 'CONVERT' feature...thanks for all the help!

  • June 5, 2003 at 4:23 pm

    #460068

    BOL is Books Online (SQL Help files)

    Nigel Moore
    ======================

  • June 5, 2003 at 4:24 pm

    #460070

    BOL = SQL Server Books Online

  • June 5, 2003 at 4:32 pm

    #460072

    Got it...thanks...

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

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