Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server DATE fields show as numbers in VFP
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2012
OS:
Windows Server 2008 R2
Miscellaneous
Thread ID:
01642533
Message ID:
01642565
Views:
25
>>>>
>>>>Are you really sure about the number 9051840 as a representation of {^2005-03-18}?
>>>
>>>Well it all displays ok when i run your code.
>>>
>>>Yes, i am sure about the representation for that date with the number 9051840 ( the string to be exact ).
>>
>>Can you give a few other paired examples of this discrepancy between SQL dates and their VFP values?
>
>
>9286560 --> 28/8/2005
>9329760 --> 27/9/2005
>9280800 --> 24/8/2005
>9324000 --> 23/9/2005

Now that i put them all together i see those numbers represent minutes.
From 23 to 27 september, that's 4 days represented by 5760, that's 1440 / day, then number of minutes per day
Why do programs stop working correctly as soon as you leave the Fox?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform