Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert from char to datetime
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Convert from char to datetime
Miscellaneous
Thread ID:
00974367
Message ID:
00974378
Views:
29
???
lcstr='20041223'
?ctod(substr(lcstr,5,2)+"/"+substr(lcstr,7,2)+"/"+substr(lcstr,1,4))
>Hi All,
>
>Can anyone help me with the conversion of '20041223' string to datetime data type in the following format 12/31/2004 ?
>
>TIA,
>Daniel M.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform