Wednesday, March 05, 2008

Missing days..


Did you know that there are dates that didnt exist ?


For example, there are no dates in year 1752 between Wednesday september 2nd and Thursday 14th in britain. People call this the cutover, it happen when a country decide to switch from Julian to Gregorian calendar, and they have to discard at least 10 days. The first switch happen in 1952, below is the October's calendar of that year











mondaytuesdaywednesdaythursdayfridaysaturdaymonday
1234151617
18192021222324
25262728293031

actually days never missing, its just dates (cant stop thinking bout the people born in those day).The interesting part is, if more than one country switch calendar at the same time, the more days were lost o.O For Indonesia we already use Gregorian Calendar since the proclamation.


You must be thinking i got this info from some website like wiki, or just googling it. Nope! I just read Mysql manual! (lho kok jadi nyambung ke database? Kapan seh gw iseng sengaja nyari info beginian^^)


Yup, mysql engine uses calendar called Proleptic Gregorian Calendar for their DATE or DATETIME values, which assume there are no such event called cutover, for this reason every dates prior the original cutover must ajjusted ie. for russian minus 13 days.


Correct me if i'm wrong, havent read any other reference regarding this, just got really stuck with my insertable view T_T (someone please show me how to work with these brats!)


1 comment:

fitrianingrum said...

eh ada ya jept ? baru tau, hehe...