By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,506 Members | 1,876 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,506 IT Pros & Developers. It's quick & easy.

Convert Julian Date to Date in MySql

P: 1
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
Oct 12 '09 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 5,058
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.
Oct 21 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.