Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CAST date and datetime
Message
From
11/06/2004 13:26:42
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Beta
Title:
CAST date and datetime
Miscellaneous
Thread ID:
00912802
Message ID:
00912802
Views:
46
I expected a casting support for date/datetime to numerical values.
? CAST(DATE() AS I) && Expected the number of days 
                    && from one given conventional date ( {^1900/1/1} is good )
*that is
? CAST(DATE() AS I)=(DATE() - {^1900/1/1}) && expected true
? CAST(DATETIME() AS B(0)) && Expected the number of seconds 
                           && from one given conventional datetime ( {^1900/1/1:} )
*that is
? CAST(DATETIME() AS B(0))=(DATETIME() - {^1900/1/1:}) && expected true
Next
Reply
Map
View

Click here to load this message in the networking platform