Re: Date Search

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55380
interpreted = N
texte = On 9/1/04 8:51 PM, "Jesse Proudman" wrote: > was posted, but it seems like with 900+ users in the database right > now, this could grow exponentially. Might it be better to store the > last time as seconds since epoch? That is what we are doing all the time. A good thing to note and to code is to always store any date in seconds since epoch. Like this you never run into this. Anyhow, just take the current dates and time and add them together in a variable then do the math thing minus the 30 minutes. Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: date search not working when type=date specified ( Charles Kline 2007)
  2. Re: date search not working when type=date specified ( Charles Kline 2007)
  3. Re: date search not working when type=date specified ( Charles Kline 2007)
  4. Re: date search not working when type=date specified ( Terry Wilson 2007)
  5. Re: date search not working when type=date specified ( Chris 2007)
  6. Re: date search not working when type=date specified ( thierry 2007)
  7. Re: date search not working when type=date specified ( Stuart Tremain 2007)
  8. Re: date search not working when type=date specified ( Gary Krockover 2007)
  9. Re: date search not working when type=date specified ( Donovan Brooke 2007)
  10. Re: date search not working when type=date specified ( Stuart Tremain 2007)
  11. date search not working when type=date specified ( Charles Kline 2007)
  12. Re: Date Search ( "Nitai @ ComputerOil" 2004)
  13. Re: Date Search ( "Dan Strong" 2004)
  14. Re: Date Search ( Jesse Proudman 2004)
  15. Re: Date Search ( "Dan Strong" 2004)
  16. Re: Date Search ( Jesse Proudman 2004)
  17. Re: Date Search ( Donovan Brooke 2004)
  18. Re: Date Search ( Kenneth Grome 2004)
  19. Date Search ( Jesse Proudman 2004)
  20. Re: summarizing date search by month... (Joseph D'Andrea 2000)
  21. summarizing date search by month... (John 2000)
  22. re: date search problem (Allen Booth 1999)
  23. re: date search problem (Allen Booth 1999)
  24. Re: Date search bug? (Kenneth Grome 1998)
  25. Re: Date search bug (Kenneth Grome 1998)
  26. Re: Date search bug (Gil Poulsen 1998)
  27. Re: Date search bug (Kenneth Grome 1998)
  28. Re: Date search bug (Gil Poulsen 1998)
  29. Re: Date search bug (John Hill 1998)
  30. Re: Date search bug (Gil Poulsen 1998)
  31. Re: Date search bug (nelson@fwgi.com 1998)
  32. Re: Date search bug (Kenneth Grome 1997)
  33. Re: Date search and sendmail (Grant Hulbert 1997)
  34. Re: Date search and sendmail (Kenneth Grome 1997)
  35. Re: Date search - yes or no (John Hill 1997)
  36. Re: Date search - yes or no (Kenneth Grome 1997)
  37. Re: Date search - yes or no (grichter@panavise.com (Gary Richter) 1997)
  38. Re: Date search - yes or no (Kenneth Grome 1997)
On 9/1/04 8:51 PM, "Jesse Proudman" wrote: > was posted, but it seems like with 900+ users in the database right > now, this could grow exponentially. Might it be better to store the > last time as seconds since epoch? That is what we are doing all the time. A good thing to note and to code is to always store any date in seconds since epoch. Like this you never run into this. Anyhow, just take the current dates and time and add them together in a variable then do the math thing minus the 30 minutes. Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com ------------------------------------------------------------- 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://webdna.smithmicro.com/ "Nitai @ ComputerOil"

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:

Weird problems with [SHOWIF]s (1997) Credit Card Checksum (1997) Major Security Hole IIS NT (1998) Not really WebCat (1997) [BoldWords] WebCat.acgib15Mac (1997) RAM variables (1997) Database changes (1998) [OT] Mac Browser Performance Tips (1999) Separate SSL Server (1997) Weird bug, or is there something amiss? (1997) WebMerchant 1.6 and https (1997) Deleting Orders (1997) US Postal Service API (2007) RE: WebCat vs. ASP (1999) Shownext problems (1999) NTbeta18 corrupted? (1997) Error handling for accountNum (1997) Help! WebCat2 bug (1997) Simple way to create unique SKU (1997) No Answer on Web Merchant Problem? (2001)