Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How Date Format convert to float Expand / Collapse
Author
Message
Posted Tuesday, November 9, 2010 6:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, December 17, 2011 11:42 PM
Points: 41, Visits: 3
While '07/01/2010' and '2010/07/01' are inserted, they are saved as 2010-07-01 00:00:00.000 in the database. So when the conversion into floats and then taking ceiling of the values,
so it is equal to 40358 how ??
please help me
Post #1017856
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse