Re: PSC recommends what date format yr 2000???
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 10633
interpreted = N
texte = >Just realized in doing some date work, were I want to sort on the year,>then the month, and then the day. Put in some test data as year 2001>Duh...I assume we should all be considering using the %Y vs the %y with the>year 2000 coming up. Sorting on 99 vs 00 is gonna drive me crazy in 3>years as to which is higher, vs sorting on 1999 vs 2000. Just thought I>would throw this out to people on this list to consider. Comments anybody.Yes, everyone would be well-advised to use %Y instead of %y for their'year' format choice in storing dates. This will help you to avoid the'year 2000' date problem many legacy database systems will have to dealwith in a couple of years. No sense in creating future problems foryourself just to save a few bytes in your database records, especiallywhen WebCat2 is so fast anyways ... right? :)Sincerely,Ken------------------------------------To leave this talk list send an email to macjordomo@smithmicro.comwith BODYunsubscribe WebDNA-Talk------------------------------------
Associated Messages, from the most recent to the oldest:
>Just realized in doing some date work, were I want to sort on the year,>then the month, and then the day. Put in some test data as year 2001>Duh...I assume we should all be considering using the %Y vs the %y with the>year 2000 coming up. Sorting on 99 vs 00 is gonna drive me crazy in 3>years as to which is higher, vs sorting on 1999 vs 2000. Just thought I>would throw this out to people on this list to consider. Comments anybody.Yes, everyone would be well-advised to use %Y instead of %y for their'year' format choice in storing dates. This will help you to avoid the'year 2000' date problem many legacy database systems will have to dealwith in a couple of years. No sense in creating future problems foryourself just to save a few bytes in your database records, especiallywhen WebCat2 is so fast anyways ... right? :)Sincerely,Ken------------------------------------To leave this
Talk List send an email to macjordomo@smithmicro.comwith BODYunsubscribe WebDNA-Talk------------------------------------
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:
Attention all list readers (1997)
[countWords]? (1997)
RE: [WebDNA] Emailer and Comcast.net (2008)
Unexpected error (1997)
WebCat2final1 crashes (1997)
Performance Issue (2000)
Firesite and WebCat (1999)
WebCat2: Formulas.db question (1997)
Default admin bug and how tech support reacted to it. (2000)
test pls delete (2001)
Transfering [text] variables (2000)
SSL problems (1998)
Using Applescript to process WebCatalog functions (1998)
Progress !! WAS: Trouble with formula.db (1997)
Webcatalog quitting (1997)
Emailer stops on Win 2000 (2002)
Fun with Dates - revisited (1997)
WebCatalog stalls (1998)
RE: Migrating to NT (1997)
Running _every_ page through WebCat ? (1997)