Community Member Profile
nant
Member since Dec 11, 2008
- Profile: /members/2662-nant.htm
- URL: www.coresharp.net
- Comments: 1
- Points: 1
Recent Blog Comments By nant
-
Careful When Trying To CAST DATETIME AS INT
Posted on May 12, 2007 at 3:05 PM
Casting to INT will truncate - normally other language does that. try this: SELECT CAST( 0.9999999999999 AS int ), CAST( 0.0000000000000001 AS int ) both of them return 0 it is quite safe to cast datetime to int :)... read more »
