SQL Server's CONVERT
Tricky, but that's how it works:
birth - varchar(6)
CONVERT(varchar, cast(birth as datetime), 101) AS Bdate
then it returns MM/DD/YYYY
Thanks to Nate!
birth - varchar(6)
CONVERT(varchar, cast(birth as datetime), 101) AS Bdate
then it returns MM/DD/YYYY
Thanks to Nate!

0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home