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.

Convert Julian Date to Date in MySql

re: Convert Julian Date to Date in MySql

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about