Re: Date question

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 53293
interpreted = N
texte = John, Thanks for the quick reply; I completely understand the concept you outlined below. I pulled the missing days thing from "man cal": "The Gregorian Reformation is assumed to have occurred in 1752 on the 3rd of September. By this time, most countries had recognized the reforma- tion (although a few did not recognize it until the early 1900's.) Ten days following that date were eliminated by the reformation, so the cal- endar for that month is a bit unusual." [dude:~] dude% cal 9 1752 September 1752 S M Tu W Th F S 1 2 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 andy On Tuesday, October 7, 2003, at 03:17 PM, John Hill wrote: > Your leap year calculation isn't right. I'm not familiar with the 11 > missing days for the Gregorian Reformation so those are not be part of > the calculation. Frankly, I've never seen a date calculator (common > one) that had the 11 days whacked (I might be wrong, it's been a long > time since I did this). Here's how it works: > > 2003 x 365 - base days up to 2003 > + 280 days - days from jan 1 > + floor(2003/4) - leap days since start (partial calc) > - floor(2003/100) - subtract leap day at century markers (partial > calc) > + floor(2003/400) - add leap day at century if multiple of 400 > >> Hi! >> >> I'm trying to implement an timestamp function and have a question. >> What does the numerical result of [math]{[date]}[/math] represent? >> On my US Mac with a date of 10/07/2003, I get 731860. This is almost >> the number of days since year 01/01/0000, but not quite.... >> >> Regular Year: 731860/365=2005.096 >> Including Leap Years: 731860/365.25=2003.723 >> Including Leap Years and 11 days missing due to the Gregorian >> Reformation (731860+11)/365.25=203.754 >> >> Oct. 7, 2003 is the 280th day of the year: 280/365.25=0.7665982 >> >> Thanks, >> >> Andy ------------------------------------------------------------- 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: [WebDNA] Quick Date Question (Govinda 2008)
  2. Re: [WebDNA] Quick Date Question (Govinda 2008)
  3. Re: [WebDNA] Quick Date Question (Steve Craig 2008)
  4. Re: [WebDNA] Quick Date Question (Gil Poulsen 2008)
  5. [WebDNA] Quick Date Question (Steve Craig 2008)
  6. Re: Silly date question ( Donovan Brooke 2006)
  7. Re: Silly date question ( Donovan Brooke 2006)
  8. Re: Silly date question ( Steve Craig 2006)
  9. Re: Silly date question ( Steve Craig 2006)
  10. Re: Silly date question ( Donovan Brooke 2006)
  11. Re: Silly date question ( Gary Krockover 2006)
  12. Re: Silly date question ( Donovan Brooke 2006)
  13. Silly date question ( Steve Craig 2006)
  14. Re: Date question ( Donovan Brooke 2003)
  15. Re: Date question ( John Peacock 2003)
  16. Re: Date question ( Donovan Brooke 2003)
  17. Re: Date question ( Donovan Brooke 2003)
  18. Re: Date question ( Alex McCombie 2003)
  19. Re: Date question ( andy mowrey 2003)
  20. Re: Date question ( John Hill 2003)
  21. Date question ( andy mowrey 2003)
  22. Re: Date Question (Dan Strong 2002)
  23. Re: Date Question (Gary Krockover 2002)
  24. Re: Date Question (Dan Strong 2002)
  25. Re: Date Question (Kenneth Grome 2002)
  26. Re: Date Question (Jeff Logan 2002)
  27. Re: Date Question (Donovan 2002)
  28. Re: Date Question (Donovan 2002)
  29. Re: Date Question (Jeff Logan 2002)
  30. Re: Date Question (Chris List Recipient 2002)
  31. Re: Date Question (Jeff Logan 2002)
  32. Re: Date Question (Dan Strong 2002)
  33. Re: Date Question (Jeff Logan 2002)
  34. Re: Date Question (Gary Krockover 2002)
  35. Re: Date Question (Jeff Logan 2002)
  36. Re: Date Question (John Peacock 2002)
  37. Re: Date Question (Dan Strong 2002)
  38. Re: Date Question (Jeff Logan 2002)
  39. Re: Date Question (Dan Strong 2002)
John, Thanks for the quick reply; I completely understand the concept you outlined below. I pulled the missing days thing from "man cal": "The Gregorian Reformation is assumed to have occurred in 1752 on the 3rd of September. By this time, most countries had recognized the reforma- tion (although a few did not recognize it until the early 1900's.) Ten days following that date were eliminated by the reformation, so the cal- endar for that month is a bit unusual." [dude:~] dude% cal 9 1752 September 1752 S M Tu W Th F S 1 2 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 andy On Tuesday, October 7, 2003, at 03:17 PM, John Hill wrote: > Your leap year calculation isn't right. I'm not familiar with the 11 > missing days for the Gregorian Reformation so those are not be part of > the calculation. Frankly, I've never seen a date calculator (common > one) that had the 11 days whacked (I might be wrong, it's been a long > time since I did this). Here's how it works: > > 2003 x 365 - base days up to 2003 > + 280 days - days from jan 1 > + floor(2003/4) - leap days since start (partial calc) > - floor(2003/100) - subtract leap day at century markers (partial > calc) > + floor(2003/400) - add leap day at century if multiple of 400 > >> Hi! >> >> I'm trying to implement an timestamp function and have a question. >> What does the numerical result of [math]{[date]}[/math] represent? >> On my US Mac with a date of 10/07/2003, I get 731860. This is almost >> the number of days since year 01/01/0000, but not quite.... >> >> Regular Year: 731860/365=2005.096 >> Including Leap Years: 731860/365.25=2003.723 >> Including Leap Years and 11 days missing due to the Gregorian >> Reformation (731860+11)/365.25=203.754 >> >> Oct. 7, 2003 is the 280th day of the year: 280/365.25=0.7665982 >> >> Thanks, >> >> Andy ------------------------------------------------------------- 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/ andy mowrey

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:

Authenticate (1998) Hiding HTML and breaking the page (1997) ssl support WDNA 5.0 (2003) Using webcat to roll apache logs (2002) PCS Frames-Default page is solution! (1997) shownext (1997) Putting Foundvariables within search. (2000) [OT] Am I an Idiot? (2004) username = 115 (1999) [WebDNA] Integration with QuickBooks (2011) convertchars and case? (1998) WebCat2 Append problem (B14Macacgi) (1997) [OT] search engine Q (2001) Setting up shop (1997) I figured it out (1999) [OT] Appropriate Signature??? (2003) Searchable WebCat (etc.) Docs ? (1997) [WebDNA] [BULK] which of these tags exist in 7.0 (2011) Forms Search Questions (1997) [WriteFile] problems (1997)