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:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:all OS:Any (all)
Assigned to:
Triage: D5 (Feature request)

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

How to repeat:
NA

Suggested fix:
Add julian date format functions, to allow conversion to and from julian dates.
[3 Sep 2007 9:49] Valerii 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))