Message
From
31/10/2016 17:58:24
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:
39
>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!
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?