Re: Date Search

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55373
interpreted = N
texte = On Jan 9, 2004, at 8:24 AM, Dan Strong wrote: > Jesse, I know I'm oversimplifying this, but my > first-thing-in-the-morning, barely-got-a-gulp-of-coffee-down-my-throat > take on this would be to convert the date as it is to something like > [seconds_since_epoch] (or some other benchmark that you prefer) and > then subtract 30 minutes worth of seconds from it, all on the fly of > course. That's what I thought. I'll look at that seconds since epoch code that 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? -- Jesse Williams-Proudman Blue Box Development :: Custom Web Solutions +1.206.778.8777 :: jesse@blueboxdev.com *Happy Holidays* ------------------------------------------------------------- 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 Jan 9, 2004, at 8:24 AM, Dan Strong wrote: > Jesse, I know I'm oversimplifying this, but my > first-thing-in-the-morning, barely-got-a-gulp-of-coffee-down-my-throat > take on this would be to convert the date as it is to something like > [seconds_since_epoch] (or some other benchmark that you prefer) and > then subtract 30 minutes worth of seconds from it, all on the fly of > course. That's what I thought. I'll look at that seconds since epoch code that 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? -- Jesse Williams-Proudman Blue Box Development :: Custom Web Solutions +1.206.778.8777 :: jesse@blueboxdev.com *Happy Holidays* ------------------------------------------------------------- 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/ Jesse Proudman

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:

Initiating NewCart (1997) Replacing entry (1998) WC1.6 to WC2 date formatting (1997) page redirect in webDNA (1997) [WebDNA] WebDNA and PHP cohabitating? (2009) Help!!!! (1997) WebDNA CAPTCHA (2008) searching withe db up three directories not working (1999) Serving images from databases (1998) catagories (1997) how to determine the actual file format of an image file? (2002) possible, WebCat2.0 and checkboxes-restated (1997) File Uploads... (1997) Undeliverable Mail (1997) Trouble with [Math] (1998) Errant Email. (1998) Protect Tag and Groups (1998) Semi OT: vbulletin and # viewing - how do that do that? (2003) WebCat cannot handle compatible search parameters? (1997) [addlineitems] (1997)