Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Leap Second Handling
Message
 
To
01/07/2012 03:03:57
Al Doman (Online)
M3 Enterprises Inc.
North Vancouver, British Columbia, Canada
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2003
Miscellaneous
Thread ID:
01547367
Message ID:
01547368
Views:
61
You cannot in VFP.

Seconds in datetime has scope from 0 to 59.

You can add field to table which indicate leap second (such as leap hour).

MartinaJ

>A leap second is being added at midnight tonight, June 30 2012. VFP (and probably most of the world's software) doesn't handle it properly:
>
>gt = {^2012-06-30 23:59:59}
>?gt + 1 && returns 2012-07-01 00:00:00
>* It should return 2012-06-30 23:59:60
>
>Just a little something (i.e. huge can of worms) to be aware of if you need second-accurate time calculations that span the leap second.
>
>Some systems are weirdly affected and may crash. For instance, the last leap second caused the SlashDot web site to crash: http://it.slashdot.org/story/12/06/30/2123248/the-leap-second-is-here-are-your-systems-ready
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Reply
Map
View

Click here to load this message in the networking platform