September 9, 2020 at 7:55 pm
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
SELECT CONVERT(varchar(10), I.InvoiceDate, 110) AS InvoiceDate
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.
September 9, 2020 at 8:11 pm
Excellent. Thank you!!!
September 9, 2020 at 8:39 pm
Just in case you're not been able to find the reference for the formats...
--Jeff Moden
Change is inevitable... Change for the better is not.
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