Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using datetime in its compressed state
Message
From
25/01/2006 16:31:16
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01090298
Message ID:
01090308
Views:
8
>Is there a way to utilize the datetime data type in its compressed state? In a table it only requires 8 bytes to store what displays as 19 characters or 14 characters if you remove the non-numeric chars. I want to create a unique character string that incorporates the datetime value plus the rightmost 3 chars from the seconds() function. I looked at using the Julian date, but it does not have the time part that I need. If there is a simpler, better way of doing this, please let me know. Thanks for any help you can give.
>Colombo.
? 0H+BINTOC(DATETIME()-{^1899-12-30:},"8")
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform