Re: Date AND time

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 40298
interpreted = N
texte = Thank you for the tips. :)On 11/25/01 10:50 PM, Bob Minor mashed the following keys :> On 11/26/01 12:28 AM, Aaron Lynch wrote: > >> I have a feeling that I will have to do a replace using getchars or >> something, but even still, how can I end up with one field that has epoch >> time or something that I can then search on and extract using [date] later? > I convert the date to seconds since 00/00/00 and time as well. Then I can > search it as I please. I store it in 2 fields so that I can search one or > both fields. I also combine the date and time and store that as well. > > date:[math]{[date]}[/math] > time:[math]{[time]}[/math] > datetime:[math]{[date]}[/math][format 5s][math]{[time]}[/math][/format] > > This produces > date:731180 > time:2592 > datetime:7311802592 > > Then you can reformat when you take it out. > > date:[format days_to_date %Y-%m-%d][yourdatefield][/format] > time:[format seconds_to_time %H:%M:%S][yourtimefield][/format] > > You also know that the first six digits of datetime are the date at least > until 269,000 days(736 years) from today and that is the last 5 digits are > the time. > ------------------------------------------------------------- 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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Date and Time as numbers (Marc Thompson 2009)
  2. Re: [WebDNA] Date and Time as numbers (Donovan Brooke 2009)
  3. Re: [WebDNA] Date and Time as numbers ("Tom Duke" 2009)
  4. Re: [WebDNA] Date and Time as numbers (Donovan Brooke 2009)
  5. Re: [WebDNA] Date and Time as numbers (Steve Craig 2009)
  6. Re: [WebDNA] Date and Time as numbers (christophe.billiottet@webdna.us 2009)
  7. [WebDNA] Date and Time as numbers (Steve Craig 2009)
  8. Re: Date and Time ( Gary Krockover 2005)
  9. Date and Time ( "Erol Guneri" 2005)
  10. Re: convert date and time ( "Dan Strong" 2005)
  11. Re: convert date and time ( Donovan Brooke 2005)
  12. Re: convert date and time ( "Dan Strong" 2005)
  13. Re: convert date and time ( Lester 2005)
  14. Re: convert date and time ( "Dan Strong" 2005)
  15. Re: convert date and time ( Lester 2005)
  16. convert date and time ( Lester 2005)
  17. Re: Cart -> Date and Time ( "Dan Strong" 2004)
  18. Re: Cart -> Date and Time ( Palle Bo Nielsen 2004)
  19. Re: Cart -> Date and Time ( Palle Bo Nielsen 2004)
  20. Re: Cart -> Date and Time ( "Dan Strong" 2004)
  21. Re: Cart -> Date and Time ( "Dan Strong" 2004)
  22. Re: Cart -> Date and Time ( Alain Russell 2004)
  23. Re: Cart -> Date and Time ( Donovan Brooke 2004)
  24. Re: Cart -> Date and Time ( "Dan Strong" 2004)
  25. Re: Cart -> Date and Time ( Palle Bo Nielsen 2004)
  26. Re: Cart -> Date and Time ( Donovan Brooke 2004)
  27. Re: Cart -> Date and Time ( "WebDna @ Inkblot Media" 2004)
  28. Re: Cart -> Date and Time ( "WebDna @ Inkblot Media" 2004)
  29. Re: Cart -> Date and Time ( Palle Bo Nielsen 2004)
  30. Re: Cart -> Date and Time ( "Dan Strong" 2004)
  31. Re: Cart -> Date and Time ( "WebDna @ Inkblot Media" 2004)
  32. Re: Cart -> Date and Time ( "Dan Strong" 2004)
  33. Re: Cart -> Date and Time ( "Dan Strong" 2004)
  34. Cart -> Date and Time ( Palle Bo Nielsen 2004)
  35. Re: date and time stamp (Donovan 2003)
  36. Re: date and time stamp (Alain Russell 2003)
  37. Re: date and time stamp (Donovan 2003)
  38. Re: date and time stamp (Alain Russell 2003)
  39. Re: date and time stamp (Donovan 2003)
  40. Re: date and time stamp (Aaron Lynch 2003)
  41. Re: date and time stamp (Donovan 2003)
  42. Re: date and time stamp (Aaron Lynch 2003)
  43. date and time stamp (Donovan 2003)
  44. Re: Converting SQL Microtime to Date and Time (Dan Strong 2003)
  45. Re: Converting SQL Microtime to Date and Time (Jesse Williams-Proudman 2003)
  46. Re: Converting SQL Microtime to Date and Time (Jesse Williams-Proudman 2003)
  47. Re: Converting SQL Microtime to Date and Time (Dan Strong 2003)
  48. Re: Converting SQL Microtime to Date and Time (sally 2003)
  49. Re: Converting SQL Microtime to Date and Time (John Peacock 2003)
  50. Re: Converting SQL Microtime to Date and Time (Jesse Williams-Proudman 2003)
  51. Re: Converting SQL Microtime to Date and Time (Frank Nordberg 2003)
  52. Re: Converting SQL Microtime to Date and Time (Glenn Busbin 2003)
  53. Re: Converting SQL Microtime to Date and Time (Jesse Williams-Proudman 2003)
  54. Re: Converting SQL Microtime to Date and Time (Glenn Busbin 2003)
  55. Converting SQL Microtime to Date and Time (Jesse Williams-Proudman 2003)
  56. Re: Date AND time (Aaron Lynch 2001)
  57. Re: Date AND time (Bob Minor 2001)
  58. Re: Date AND time (Aaron Lynch 2001)
  59. Re: Date AND time (Bob Minor 2001)
  60. Date AND time (Aaron Lynch 2001)
  61. Date and Time Format changes in WC4 (Glenn Busbin 2000)
  62. Re: Date and Time Analyzer (Nicolas Verhaeghe 2000)
  63. Date and Time Analyzer (Bob Minor 2000)
  64. Launch date and time? (Kenneth Grome 1999)
  65. Date and Time Math (Jeremy Pocock 1997)
Thank you for the tips. :)On 11/25/01 10:50 PM, Bob Minor mashed the following keys :> On 11/26/01 12:28 AM, Aaron Lynch wrote: > >> I have a feeling that I will have to do a replace using getchars or >> something, but even still, how can I end up with one field that has epoch >> time or something that I can then search on and extract using [date] later? > I convert the date to seconds since 00/00/00 and time as well. Then I can > search it as I please. I store it in 2 fields so that I can search one or > both fields. I also combine the date and time and store that as well. > > date:[math]{[date]}[/math] > time:[math]{[time]}[/math] > datetime:[math]{[date]}[/math][format 5s][math]{[time]}[/math][/format] > > This produces > date:731180 > time:2592 > datetime:7311802592 > > Then you can reformat when you take it out. > > date:[format days_to_date %Y-%m-%d][yourdatefield][/format] > time:[format seconds_to_time %H:%M:%S][yourtimefield][/format] > > You also know that the first six digits of datetime are the date at least > until 269,000 days(736 years) from today and that is the last 5 digits are > the time. > ------------------------------------------------------------- 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://search.smithmicro.com/ Aaron Lynch

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:

PCS Customer submissions ? (1997) [sendmail] problem getting silly now =\ (2000) Re:trouble (1997) about this server and links to who (1997) slightly OT: advertising schemes (2004) WebCatalog usage (1997) two unique banners on one page (1997) code below an [authenticate] gets evaluated? (2000) Extended [ConvertChars] (1997) Re:Realtime Transaction Processing (1999) [WebDNA] WebDNA DE purchase (2008) [WebDNA] Moving sites to a HostGator dedicated server (2008) READFILE command? (1998) Fwd: Re(2): Password and Allow commands (1998) error -108 (1997) Authorize.net, SIM, tcpconnect and applescript (2003) WebCatalog f2 Installation (1997) WebCat2 beta 11 - new prefs ... (1997) suffix mapping, use of cache, etc. (1997) Digest for 4/18/97 (1997)