Re: Date AND time
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 40294
interpreted = N
texte = 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 cansearch it as I please. I store it in 2 fields so that I can search one orboth 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 producesdate:731180time:2592datetime:7311802592Then 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 leastuntil 269,000 days(736 years) from today and that is the last 5 digits arethe time.Robert MinorDirector of Internet Services------------------------------------------------------------Cybermill Communicationshttp://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development andhosting services on Macintosh, Windows NT, Unix, and AS/400.All your websites are belong to us!-------------------------------------------------------------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:
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 cansearch it as I please. I store it in 2 fields so that I can search one orboth 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 producesdate:731180time:2592datetime:7311802592Then 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 leastuntil 269,000 days(736 years) from today and that is the last 5 digits arethe time.Robert MinorDirector of Internet Services------------------------------------------------------------Cybermill Communicationshttp://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development andhosting services on Macintosh, Windows NT, Unix, and AS/400.All your websites are belong to us!-------------------------------------------------------------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/
Bob Minor
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:
FYI: virus alert (1996)
[math] with first letter in field? (1997)
Security Question (1997)
Shipping charges based on dollar level (1997)
Retrieve deleted files (2001)
Overridding E-Mailer (1998)
can WC render sites out? (1997)
[WebDNA] cron - curl to replace triggers.. (2009)
GoLive CyberStudio 1.0.1 (1997)
Protecting webdelivery (1997)
Online reference (1997)
Entry point? Security w/ dbase helper? (1997)
OT: Yahoo email errors...... (2006)
Help name our technology! I found it (1997)
WebCatalog for guestbook ? (1997)
GuestBook example (1997)
RE: New WebCatalog Version !!! (1997)
mass mailing (1998)
[SHOWIF AND/OR] (1997)
Removing [showif] makes a big difference in speed (1997)