Richard
Member since Dec 11, 2008
- Profile: /members/1943-richard.htm
- Comments: 1
Recent Blog Comments By Richard
-
Careful When Trying To CAST DATETIME AS INT
Posted on Aug 3, 2007 at 9:24 AM
If you cast first to float, it works. Try: select cast('11 Jan 2007 4:00am' as datetime), cast(cast('11 Jan 2007 4:00am' as datetime) as float), cast(cast(cast('11 Jan 2007 4:00am' as datetime) as float) as int), cast(cast('11 Jan 2007 4:00am' as datetime) as int), cast(cast(cast(cast('11 Jan ... read more »