Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server DATE fields show as numbers in VFP
Message
 
To
31/10/2016 17:07:57
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:
01642574
Views:
36
>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!
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