Phil Chapman
asked on
MSSQL Convert Char To Date
I have a table where the DateTime is stored as Char(14)
Example: 11272006124606 mmddyyyyhhmmss
Question:
How can I convert 11272006124606 to 2006-11-27
Example: 11272006124606 mmddyyyyhhmmss
Question:
How can I convert 11272006124606 to 2006-11-27
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.
ASKER
Thanks for the help
Open in new window
O/p
2006-11-27