Post reply

Formatting dates returned in query

  • September 9, 2020 at 7:55 pm

    #3787409

    I have a statement below in a query that is returning the invoiced date as 2020-08-24 22:00:10.493

    How can I get those query results in MM-DD-YYYY which I think is format 101?

     

    SELECT I.InvoiceDate

  • September 9, 2020 at 8:03 pm

    #3787410

    SELECT CONVERT(varchar(10), I.InvoiceDate, 110) AS InvoiceDate

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

  • September 9, 2020 at 8:11 pm

    #3787412

    Excellent.  Thank you!!!

  • September 9, 2020 at 8:39 pm

    #3787420

    Just in case you're not been able to find the reference for the formats...

    https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver15

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • September 15, 2020 at 6:16 pm

    This was removed by the editor as SPAM

  • October 29, 2020 at 6:03 am

    This was removed by the editor as SPAM

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

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