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:
GrandTotal not right (1997)
calculating tax rates, mail order solutions and version 2 (1997)
PageMaker/Quark to db (1999)
A question on sub-categories (1997)
CC Merchant suggestions?? (1997)
Emailer or [sendmail] questions ... (1998)
Order not created error (never mind) (1997)
Cart questions (1997)
WebCat2 beta FTP site (1997)
Caching pages...again (2001)
suffix mapping, use of cache, etc. (1997)
Browser Problem?!? Still getting Error message using POST! (1997)
[WebDNA] Virtual server (2011)
Error log crashes server? (1999)
OT: automating a POST (2002)
[WebDNA] Admin group limits (2010)
splitting numbers in webDNA? (1997)
WebMerchant 1.6 and https (1997)
Carts & Refering URLs (1997)
Need help, multiple shipping options (2000)