Re: date format (another question)
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26788
interpreted = N
texte = Joe,Thanks for the info and your experiences. The site I am working on willhave most results sorted by date. This is the main reason I wonder if itwill be faster to format dates in this manner.I would love to hear other comments on performance of storing dates inhuman readable form as well as those that have done it as text sortable.Since almost every results set will be sorted by date, and I will alsohave some searches of the 'documents added inthe past xx days'. And asmentioned in an earlier email this project for work could potentiallyreplace an Oracle database so I need to take whatever steps I can tooutperform that database.Basically I am doing a document repository and there will be manydocuments added each day (the current Oracle database size is supposed tobe around 3.5 gig). So there will be lots of documents and lots ofsorting. If we go with WebCat, probably 3-400,000 searches per workday.Thanks for any advice.>>[math]MyDate={[date]}[/math]>>Will give you a variable that contains today's date as a number of days>since some time in the past that I can't remember.>>To make it readable.... [format days_to_date][MyDate][/format]>>You should note however... that you'll need to do these types of>conversions every time the fields are referenced.>>I took Ken's advice and implemeted one site using the days_to_date business>and now I find it more work then it was worth to search for things like>find all records created in the month of December.>>Furthermore, since I learned how to use the date attribute in math>calculations and search contexts, I haven't found a situation where using>the mm/dd/yyyy doesn't work for searchs, sorts and calculations. So I think>I'm actually going to using the [date] without changing it to days on the>next system I build.>>___Joe___>>>>At 9:56 AM 1/31/00, Dale Therio wrote:>>> Typhoon Pro v3.0.7 on Mac w/Webstar>>>>>> A similar question,>>>>>> I am developing a new site and based on the constant recommendation by>>> Ken G. and others on the list I will set the date format the number>>> searchable.>>>>>> The dubm question is, how do I save the date in the database in this>>> format? Using [date] by itself doesn't do the trick.>>>>>> I have looked in the docs, but haven't found the proper place yet.>>> Additionally, once I have it saved, how do I get the date back into human>>> readable form so I can display normal type dates.>>>>>> Thanks!>>>>>> Dale>>>>>> >No, not if the '02' is in a database...>>> >>>> >I think [format days_to_date] is what you want, but I don't know for>>> >sure (cuz I'm on 2.x and don't use that tage)>>> >>>> >hth>>> >-Aaron>>> >>>> >Joseph D'Andrea wrote:>>> >>>>> >> At 11:00 AM 1/30/00, Brian Wachter wrote:>>> >> >> Is there an easy way to format 02 as February, using the [format]>>> >> >> context for example?>>> >>>>> >> It's accomplished using the [date] tag.>>> >>>>> >> ___Joe___>>>>>>>>> ------------------------------------------------------------->>> 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>>>>>>_________________________________________________>Joseph D'Andrea JoeDan@West21.com>WEST21.com Internet services for the 21st Century> http://www.west21.com/>_________________________________________________>>>>>------------------------------------------------------------->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 digest@talk.smithmicro.com>-- Dale Therio Dresdner Kleinwort Benson Research+49 (0) 69 26 31 9977 (o) Jürgen-Ponto-Platz 1+49 (0) 69 26 31 1379 (f) 60301 Frankfurt+49 (0) 170 93 43 610 (m) Germany-------------------------------------------------------------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:
Joe,Thanks for the info and your experiences. The site I am working on willhave most results sorted by date. This is the main reason I wonder if itwill be faster to format dates in this manner.I would love to hear other comments on performance of storing dates inhuman readable form as well as those that have done it as text sortable.Since almost every results set will be sorted by date, and I will alsohave some searches of the 'documents added inthe past xx days'. And asmentioned in an earlier email this project for work could potentiallyreplace an Oracle database so I need to take whatever steps I can tooutperform that database.Basically I am doing a document repository and there will be manydocuments added each day (the current Oracle database size is supposed tobe around 3.5 gig). So there will be lots of documents and lots ofsorting. If we go with WebCat, probably 3-400,000 searches per workday.Thanks for any advice.>>[math]MyDate={[date]}[/math]>>Will give you a variable that contains today's date as a number of days>since some time in the past that I can't remember.>>To make it readable.... [format days_to_date][MyDate][/format]>>You should note however... that you'll need to do these types of>conversions every time the fields are referenced.>>I took Ken's advice and implemeted one site using the days_to_date business>and now I find it more work then it was worth to search for things like>find all records created in the month of December.>>Furthermore, since I learned how to use the date attribute in math>calculations and search contexts, I haven't found a situation where using>the mm/dd/yyyy doesn't work for searchs, sorts and calculations. So I think>I'm actually going to using the [date] without changing it to days on the>next system I build.>>___Joe___>>>>At 9:56 AM 1/31/00, Dale Therio wrote:>>> Typhoon Pro v3.0.7 on Mac w/Webstar>>>>>> A similar question,>>>>>> I am developing a new site and based on the constant recommendation by>>> Ken G. and others on the list I will set the date format the number>>> searchable.>>>>>> The dubm question is, how do I save the date in the database in this>>> format? Using [date] by itself doesn't do the trick.>>>>>> I have looked in the docs, but haven't found the proper place yet.>>> Additionally, once I have it saved, how do I get the date back into human>>> readable form so I can display normal type dates.>>>>>> Thanks!>>>>>> Dale>>>>>> >No, not if the '02' is in a database...>>> >>>> >I think [format days_to_date] is what you want, but I don't know for>>> >sure (cuz I'm on 2.x and don't use that tage)>>> >>>> >hth>>> >-Aaron>>> >>>> >Joseph D'Andrea wrote:>>> >>>>> >> At 11:00 AM 1/30/00, Brian Wachter wrote:>>> >> >> Is there an easy way to format 02 as February, using the [format]>>> >> >> context for example?>>> >>>>> >> It's accomplished using the [date] tag.>>> >>>>> >> ___Joe___>>>>>>>>> ------------------------------------------------------------->>> 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>>>>>>_________________________________________________>Joseph D'Andrea JoeDan@West21.com>WEST21.com Internet services for the 21st Century> http://www.west21.com/>_________________________________________________>>>>>------------------------------------------------------------->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 digest@talk.smithmicro.com>-- Dale Therio Dresdner Kleinwort Benson Research+49 (0) 69 26 31 9977 (o) Jürgen-Ponto-Platz 1+49 (0) 69 26 31 1379 (f) 60301 Frankfurt+49 (0) 170 93 43 610 (m) Germany-------------------------------------------------------------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
Dale Therio
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:
Help formatting search results w/ table (1997)
Showif, Hideif reverse logic ? (1997)
WebCat and image maps (1997)
[MIDDLE %22] Broken (2003)
[WebDNA] Setting secure cookie (2009)
Need relative path explanation (1997)
Navigator 4.01 (1997)
off topic fetch vs PCS photomaster (1997)
[SearchString] problem with [search] context (1997)
WebTen and WebCat (1997)
Re:Email Problem (1997)
can WC render sites out? (1997)
Date sorting (2000)
WebCatalog for guestbook ? (1997)
WebDNA Partner edition .. (2002)
[include] affect on filepaths for links? (1997)
form data submission gets truncated (1997)
For those of you not on the WebCatalog Beta... (1997)
Forbidden CGI Error (1997)
Re:2nd WebCatalog2 Feature Request (1996)