Re: [WebDNA] Using UNIX timestamps for dates/times
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106755
interpreted = N
texte = This is what I eventually ended up doing as well. -Dan On 6/15/2011 12:17 PM, Kenneth Grome wrote: > There's no reason why you can't store human readable dates > and times in your db as well as "seconds since" times, > right? Then you have the best of both worlds. > > Like I said earlier, db size has never bothered me so I > seldom worry about trying to minimize the volume of data any > more. Why not store the dates / times in as many different > formats as you find useful? > > Sincerely, > Kenneth Grome > > > >> Ken / Govinda, >> >> Thanks for the feedback. Sometimes I need use date/time >> calculations - i.e. how much time has passed since a >> page refresh - and if the period passes over midnight >> for example then a seconds_since method of storage makes >> sense. >> >> I also have some clients who want to embargo the release >> of content until a certain date and time - again a >> seconds since approach would make searches easier here. >> >> Anyhow before I dive into this I just wanted to see what >> others were doing. >> >> Take care >> - Tom > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list
. > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
This is what I eventually ended up doing as well. -Dan On 6/15/2011 12:17 PM, Kenneth Grome wrote: > There's no reason why you can't store human readable dates > and times in your db as well as "seconds since" times, > right? Then you have the best of both worlds. > > Like I said earlier, db size has never bothered me so I > seldom worry about trying to minimize the volume of data any > more. Why not store the dates / times in as many different > formats as you find useful? > > Sincerely, > Kenneth Grome > > > >> Ken / Govinda, >> >> Thanks for the feedback. Sometimes I need use date/time >> calculations - i.e. how much time has passed since a >> page refresh - and if the period passes over midnight >> for example then a seconds_since method of storage makes >> sense. >> >> I also have some clients who want to embargo the release >> of content until a certain date and time - again a >> seconds since approach would make searches easier here. >> >> Anyhow before I dive into this I just wanted to see what >> others were doing. >> >> Take care >> - Tom > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list. > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us
Dan Strong
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:
Protecting webdelivery (1997)
Sendmail not sending (2004)
Server Load (2000)
Sorting problem (2002)
searching illegal HTML (2002)
Test (2001)
[cart] (1998)
How To question on setting up downloads (1997)
Some Questions (1997)
Max Record length restated as maybe bug (1997)
error (2000)
help needed w/ search params (1998)
[WebDNA] [BULK] Problem in Database "\x0B" (2011)
date formatting for CC card expiration date check (1998)
[shownext] support - MacOS (1997)
variables in [addlineitem] (1998)
Has anyone on the list heard of i2? (2000)
change the number format (1997)
REPOST: Upgrage pricing... The future of WebCatalog is coming with 4.0... (2000)
Email encryption (1998)