mikemcc1
asked on
DateAdd returns different date from sql 2000 and vb6
In sq 2000, select dateadd("d",39495,0) returns 2008-02-19.
In vb6, from the immediate window, ? dateadd("d",39495,0) shows a value of 2/17/2008.
The difference is 2 days, can someone explain what I am not understanding here. Running windows xp.
thanks
In vb6, from the immediate window, ? dateadd("d",39495,0) shows a value of 2/17/2008.
The difference is 2 days, can someone explain what I am not understanding here. Running windows xp.
thanks
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
indeed... as they work very close together, I confuse the 2 :(
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
I suspect you are refering to Sybase instead of IBM. To my knowledge IBM was never involved in SQL Server.