Convert Julian Date to Date in MySql

[smdmca]

I have Julian date, I want to convert it into date. Is there any function in MySql to convert Julian date to date

eg- Julian Date- 2455116
Date - Oct - 12, 2009

[Atli]

Unfortunately not. MySQL has no such function yet. (See Bug 2585)

You are best of, at the moment, using your front-end code to convert between the two types.
PHP, for instance, has the jdtounix function, which converts Julian days into a Unix timestamp.