Re: [WebDNA] Using UNIX timestamps for dates/times

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 106754
interpreted = N
texte = 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 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Using UNIX timestamps for dates/times (Dan Strong 2011)
  2. Re: [WebDNA] Using UNIX timestamps for dates/times (Kenneth Grome 2011)
  3. Re: [WebDNA] Using UNIX timestamps for dates/times (Tom Duke 2011)
  4. Re: [WebDNA] Using UNIX timestamps for dates/times (Govinda 2011)
  5. Re: [WebDNA] Using UNIX timestamps for dates/times (Kenneth Grome 2011)
  6. [WebDNA] Using UNIX timestamps for dates/times (Tom Duke 2011)
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 Kenneth Grome

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:

Sorting nested search (2003) Configuring E-mail (1997) [WebDNA] Writefile size limit? (2011) TeaRoom (1997) HTML Editors (1997) email code (1998) Not really WebCat (1997) [WebDNA] Search question (2013) listfiles sort by moddate (2002) New NT beta available (1997) setlineitem quantity to zero? (2000) F3 crashing server (1997) WebMerchant 1.6 and https (1997) Summary search -- speed (1997) [WebDNA] exclusivelock (2011) [shownext] support - MacOS (1997) Error: Too many nested [xxx] contexts (1997) Using [Include] Context (1999) [shipCost] math formula? (1997) RE: protect tag on NT (1997)