JElster
asked on
sql server - convert DATETIME to formated string
Hi..
I have the following DATETIME field. PURCHASED_DATE = 2013-01-02 09:00:00.000
I need to return the field / data in the following format
as
'Wed Jan 2 9:00 AM'
thx
I have the following DATETIME field. PURCHASED_DATE = 2013-01-02 09:00:00.000
I need to return the field / data in the following format
as
'Wed Jan 2 9:00 AM'
thx
SELECT DATENAME(dw, GETDATE()) + ' ' + CONVERT(nvarchar(50), getdate(), 100)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.