Re: Date AND time

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 40294
interpreted = N
texte = 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:7311802592Then 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.Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development and hosting services on Macintosh, Windows NT, Unix, and AS/400.All your websites are belong to us! ------------------------------------------------------------- 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)
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:7311802592Then 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.Robert Minor Director of Internet Services ------------------------------------------------------------ Cybermill Communications http://www.cybermill.com http://www.merchantmaker.comProviding Ecommerce and interactive website development and hosting services on Macintosh, Windows NT, Unix, and AS/400.All your websites are belong to us! ------------------------------------------------------------- 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/ Bob Minor

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:

[WebDNA] Error 500 with SUMM=T (2017) Number searching/formats (1998) Need relative path explanation (1997) Shopping Cart Problem (1998) [math] storage of variables (1997) Most Efficiant Way to do restricted Areas (1997) Database changes (1998) WebCatalog NT beta 18 now available (1997) Almost Real Time (2002) [WebDNA] WebSite Examples (2008) unusual search problem (1998) Unexceling (was I need a smart quote...) (1999) Strange intermittent WebDNA problems (2008) WebCat2 - storing unformatted date data? (1997) [WebDNA] Storing time in 24hr format (2016) Security Question (1997) [WebDNA] [regex] (2015) Images in the page without using separate image files ... (2003) Some Advise needed (1997) Encrypting WebDNA Templates (1999)