Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Binary Code
Message
 
 
To
12/01/2006 11:03:22
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01086100
Message ID:
01086135
Views:
17
Ian,

Give us another date and what its decimal value is and we can reverse engineer the algorithm.

>The binary format is stored as a decimal.
>
>An example is 131402254 and the date should be 14/10/2005
>
>on the server the column is listed as (decimal(18,0),Null)
>
>Does this help?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform