Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert date
Message
From
05/05/2014 11:37:50
 
 
To
05/05/2014 11:00:44
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Environment versions
SQL Server:
SQL Server 2012
Application:
Web
Miscellaneous
Thread ID:
01599545
Message ID:
01599554
Views:
43
>We've got a data file that has dates in 'dd-mm-yyyy (time)' format (and coming in as a string) and need them in 'standard amurican' 'mm-dd-yyyy (time)'.
>
>What's the best way to do this conversion?

>
>Have you tried using the CAST() function?

Cast just has issues, Convert says "Conversion failed when converting date and/or time from character string
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform