We\u2019ve got data that uses a funky date format \u2014 not a true julian date\u00a0 but the Year followed by the DAY of the year.<\/p>\n
i.e.<\/p>\n
2010005 = January 5th, 2010<\/p>\n
2010031 = January 31st 2010<\/p>\n
2010365 = December 31st 2010<\/p>\n
This little snippet of code will allow you to select it from the mysql database and convert it to a real date.<\/p>\n
select date_sub(date_add(concat(substr(jdate,1,4),\u2019-01-01\u2032), interval substr(jdate,5,3) day ), interval 1 day)<\/p><\/blockquote>\n
so in this example below returns May 2 ( the 123rd day of 2004 is May 2 )<\/p>\n
select date_sub(date_add(concat(substr(\u20182004123\u2032,1,4),\u2019-01-01\u2032), interval substr(\u20182004123\u2019,5,3) day ), interval 1 day)<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"
We\u2019ve got data that uses a funky date format \u2014 not a true julian date\u00a0 but the Year followed by the DAY of the year. i.e. 2010005 = January 5th, 2010 2010031 = January 31st 2010 2010365 = December 31st … Continue reading