Re: date format (another question)
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26794
interpreted = N
texte = >Actually I hadn't considered the performance impact of sorting by date vs. >sorting by days. Perhapss there is a performance hit. I'd love to know what >you learn. > >There is one Y2.1K implication of using days vs. dates. The current date is >something like 73000. And you might be tempted to not type this as a >numeric field in your sorts and consider it a text field. But in 25,000 >days -- or 68 years from now -- the days will change to a number greater >then 99999 and you'll be in trouble.
Joe, this is incorrect. The current date is nowhere near 73000. It is not a 5-digit string at all, it is a 6-digit string, and today is 730515.This means it will not change to a 7-digit string until 11/27/2737 -- more than 700 years from now. Therefore, unless you actually have to deal with dates 737+ years into the future, there's no reason to worry about my suggestion to store dates as days since 0000.And if 700 years still seems too close for comfort, you can simply append a zero to the [math]{[date]}[/math] value which will extend the 11/27/2737 problem date to 01/25/7379, thus takes you so far into the future that the issue no longer exists for all practical purposes ...:)================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
>Actually I hadn't considered the performance impact of sorting by date vs. >sorting by days. Perhapss there is a performance hit. I'd love to know what >you learn. > >There is one Y2.1K implication of using days vs. dates. The current date is >something like 73000. And you might be tempted to not type this as a >numeric field in your sorts and consider it a text field. But in 25,000 >days -- or 68 years from now -- the days will change to a number greater >then 99999 and you'll be in trouble. Joe, this is incorrect. The current date is nowhere near 73000. It is not a 5-digit string at all, it is a 6-digit string, and today is 730515.This means it will not change to a 7-digit string until 11/27/2737 -- more than 700 years from now. Therefore, unless you actually have to deal with dates 737+ years into the future, there's no reason to worry about my suggestion to store dates as days since 0000.And if 700 years still seems too close for comfort, you can simply append a zero to the [math]{[date]}[/math] value which will extend the 11/27/2737 problem date to 01/25/7379, thus takes you so far into the future that the issue no longer exists for all practical purposes ...:)================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Kenneth Grome
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
New Web Site Developers Database (1996)
Template cache problem with WC4 on Mac OS X (2000)
NT Version on IIS 4.0 (1997)
WebSiphon and MGI links (2000)
international time (1997)
WebCat 5 Intranet Question (2003)
New public beta available (1997)
Major Security Hole (1998)
WebCat2 several catalogs? (1997)
BBEdit and WebCatalog 2.0? (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Handy Browser Counter Tip (1997)
IE Cache Problems... (1999)
WC TableGrinder (1997)
Location of Browser Info.txt file (1997)
WebDelivery: One step closer !! (1997)
New syntax feedback for 4.0 (2000)
Has anyone integrated ZipBurst with WebCat? (2000)
WebMerchant 1.6 and SHTML (1997)