Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server DATE fields show as numbers in VFP
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2012
OS:
Windows Server 2008 R2
Divers
Thread ID:
01642533
Message ID:
01642565
Vues:
26
>>>>
>>>>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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform