var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL Server/Excel Date discrepancy
Here's a strange one - anyone else come across this :
select cast(cast ('08-dec-2005' as datetime ) as int) returns 38692
In Excel2002 SP3
Put the same date in a cell and format it as a number and you get 38694
Presumably the products have a different start date
Ran accross the same problem with a third party application a while back.
The issue also is apparent in Access.
THe vender had created a process to delete based upon numerical representation of the date. Caused all kind of issues.