Re: Date AND time
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 40298
interpreted = N
texte = Thank you for the tips.:)On 11/25/01 10:50 PM, Bob Minor mashed the following keys :> On 11/26/01 12:28 AM, Aaron Lynch
wrote:> >> I have a feeling that I will have to do a replace using getchars or>> something, but even still, how can I end up with one field that has epoch>> time or something that I can then search on and extract using [date] later?> I convert the date to seconds since 00/00/00 and time as well. Then I can> search it as I please. I store it in 2 fields so that I can search one or> both fields. I also combine the date and time and store that as well.> > date:[math]{[date]}[/math]> time:[math]{[time]}[/math]> datetime:[math]{[date]}[/math][format 5s][math]{[time]}[/math][/format]> > This produces> date:731180> time:2592> datetime:7311802592> > Then you can reformat when you take it out.> > date:[format days_to_date %Y-%m-%d][yourdatefield][/format]> time:[format seconds_to_time %H:%M:%S][yourtimefield][/format]> > You also know that the first six digits of datetime are the date at least> until 269,000 days(736 years) from today and that is the last 5 digits are> the time.>-------------------------------------------------------------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 Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Thank you for the tips.:)On 11/25/01 10:50 PM, Bob Minor mashed the following keys :> On 11/26/01 12:28 AM, Aaron Lynch wrote:> >> I have a feeling that I will have to do a replace using getchars or>> something, but even still, how can I end up with one field that has epoch>> time or something that I can then search on and extract using [date] later?> I convert the date to seconds since 00/00/00 and time as well. Then I can> search it as I please. I store it in 2 fields so that I can search one or> both fields. I also combine the date and time and store that as well.> > date:[math]{[date]}[/math]> time:[math]{[time]}[/math]> datetime:[math]{[date]}[/math][format 5s][math]{[time]}[/math][/format]> > This produces> date:731180> time:2592> datetime:7311802592> > Then you can reformat when you take it out.> > date:[format days_to_date %Y-%m-%d][yourdatefield][/format]> time:[format seconds_to_time %H:%M:%S][yourtimefield][/format]> > You also know that the first six digits of datetime are the date at least> until 269,000 days(736 years) from today and that is the last 5 digits are> the time.>-------------------------------------------------------------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 Web Archive of this list is at: http://search.smithmicro.com/
Aaron Lynch
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:
Question about replacing words (1998)
[WebDNA] API - Flickr (2011)
UPDATE PROBLEM (1997)
Re[2]: 2nd WebCatalog2 Feature Request (1996)
calculating tax rates, mail order solutions and version 2 (1997)
Hyperboard users wanting a quoted message (1998)
WebCat2 beta 11 - new prefs ... (1997)
[BULK] [WebDNA] New Webdna framework ! ... (addresses some initial concerns... coming into the design of a large project) (2012)
suffix mapping, use of cache, etc. (1997)
quantity minimum problem (1997)
[OT] two domains one site... (2005)
Re1000002: Setting up shop (1997)
Data Type Search Problem (2004)
WC1.6 to WC2 date formatting (1997)
Re:Help name our technology! (1997)
One tough Cookie (1998)
Mail Server Needed. (1998)
Generating unique SKU from [cart] - Still Stumped... (1997)
Text data with spaces in them... (1997)
FW: ANother SHOWIF problem (1997)