Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server DATE fields show as numbers in VFP
Message
From
01/11/2016 03:00:45
 
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:
01642581
Views:
30
>>In Management Studio, can you "Script Table > CREATE to > Clipboard" and paste it here?
>
>Ok after checking, you are completely right, the data is not in date format, but rather in a format as minutes from january 1, 1988 which is plain weird.
>
>Now if i run
>result = SQLEXEC(Handle, "select dateadd(minute, 9286560, '1988/01/01')")
>i get the correct result ( 28/8/2005)
>
>Many thanks for driving me to the right direction!

Glad to have helped (& long time no see...).
----------------------------------
António Tavares Lopes
Previous
Reply
Map
View

Click here to load this message in the networking platform