Phil Chapman
asked on
DateTime Conversion
How do I conver a DateTime date field to display only the date.
Example:
SELECT Customer,Invoice,InvoiceDa te
From Invoices
Where
Customer = 123
Normal Results:
123 45678 2012-10-222 11:15:03:00
What I need
123 45678 2012-10-222
Example:
SELECT Customer,Invoice,InvoiceDa
From Invoices
Where
Customer = 123
Normal Results:
123 45678 2012-10-222 11:15:03:00
What I need
123 45678 2012-10-222
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
https://www.experts-exchange.com/Database/Miscellaneous/A_1499-DATE-and-TIME-don%27t-be-scared-and-do-it-right-the-first-time.html
above comment is correct, in that regards...
I presume the 222 (day) is a typo