Bug #2585 Julian date character function
Submitted: 30 Jan 2004 11:28 Modified: 3 Sep 2007 9:49
Reporter: Matt Ryan Email Updates:
Status: Verified Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:all OS:Any (all)
Assigned to: CPU Architecture:Any

[30 Jan 2004 11:28] Matt Ryan
Mysql lacks julian date format functions, from real or military style julian date.

How to repeat:

Suggested fix:
Add julian date format functions, to allow conversion to and from julian dates.
[3 Sep 2007 9:49] Valeriy Kravchuk
Thank you for a reasonable feature request.
[19 Mar 2008 22:12] Jorge Vicens
Here is a Julian date conversion:

concat(date_format( `table`.`datefield`,'%y' ),substring(concat('00',dayofyear( `invoice`.`date`)),-3))
[19 Mar 2008 22:13] Jorge Vicens
Ooops... that's

concat(date_format(`table`.`datefield`,'%y' ),substring(concat('00',dayofyear( `table`.`datefield`)),-3))