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.-DanOn 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.-DanOn 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:
[SearchString] usage (1997)
[showif] not working (2003)
Security (1998)
I'm having trouble using [url][interpret][math] together in lookup (1997)
Bug (feature) in v6 listfiles shows hidden files ... (2004)
WebDNA Solutions ... sorry! (1997)
Help! WebCat2 bug (Ben's input) (1997)
SiteEdit Pro Update Announcement (1997)
Configuring E-mail (1997)
Help needed! (1998)
[WebDNA] PayPal IPN (was: paypal FINALLY!!!!) (2009)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Signal Raised Error (1997)
installing webcatalog problem. HELP! (1998)
WCS Newbie question (1997)
Resolving variables into field names (1998)
OT: Typhoon (1998)
need e-commerce recommendation (2004)
Help name our technology! (1997)
WebCat for mass emailings (1997)