Welcome to
Sign in
|
Help
Search
Home
Blogs
External Feeds
Forums
Photos
Downloads
About Us
»
English Section
»
Question of the Day
»
datetime SQL vs Excel (why the difference?)
datetime SQL vs Excel (why the difference?)
03-14-2010, 10:48 PM
darius2
Joined on 01-23-2007
db_datawriter
datetime SQL vs Excel (why the difference?)
Reply
Quote
select CAST(FLOOR(CAST(cast('2010-02-01' as datetime) AS FLOAT)) AS int) = 40208
40208 in Excel = 01/30/2010
Filed under:
int
,
sql
,
cast
,
excel
,
datetime
Report abuse
View Complete Thread