Wednesday, March 29, 2006

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!

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home