Posted: 01 December 2021 at 11:01pm | IP Logged | 8
|
post reply
|
|
early in my IT career i began using what i believed was metric dating: yyyymmdd in numeric fields on projects. all date functionality (this was for a life insurance company that relied heavily on dates and periods for interest and value/worth calculations for literally millions of clients) this made a VERY noticeable difference in the execution speed to do the required calculations. i have used that yyyymmdd format, when required, in all subsequent contracts/projects.
i no longer think of dates in month-first or day-first ... it's year-first for simplicity.
edited to add: i'm sure everyone here is aware that to keep the calendar year accurate, one day is added every four years. there are 2 other "rules": basically, if the year is divisible by 4, add Feb 29th, but if the year is divisible by 100, do NOT add Feb 29th, unless the year IS divisible by 400, then DO add Feb 29th ... and i think i calculated the next "rule" way back when: if the year IS divisible by 3200*, do NOT include Feb 29th!
*i can't remember the exact number, but it was very large !
Edited by Paul Reis on 01 December 2021 at 11:20pm
|