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:

[checkboxes] and WebCat (2) (2000) [WebDNA] Basic Search (2008) showif and cart (1997) Experience with creating real dynamic solutions?????? (1998) $purchase WITHOUT creditcar (1997) Re:2nd WebCatalog2 Feature Request (1996) WebCatalog 2.1 License for Sale (1998) [WebDNA] Talk List (2018) Weird bug, or is there something amiss? (1997) 3RD POST Character limit in [Search]? (1998) Permissions Ignored - PLEASE HELP (2003) creator code (1997) can WC render sites out? (1997) grouping fields question (1998) [Replace] (2000) FlushDatabase Suggestion (1998) [WebDNA] [OT] potential cheap WebDNA server? (2009) Am I going senile? (Price recalc based on quantity) (1997) Ok here is a question? (1997) Problems appending to database (1997)