01-06-2009 06:23 PM
01-06-2009 08:49 PM
01-07-2009 04:07 AM
12-14-2012 06:03 AM
I am trying to convert Julian date 47712 into date format. I used the above formula but it only works up to 41199?
12-14-2012 07:29 AM
This number comes from Oracle and we need to convert into TD data.
Can you give an example of how to convert this number and define the rules? I had many different methods and formulas that work with lower number.
12-14-2012 10:54 AM
It's not an Oracle Julian date which is based on 4712 BC.
Why do you expect me to "convert this number and define the rules", this is your task my crystal ball is broken.
12-17-2012 01:01 AM
Sorry for jumping in.
Been tehre, done that.
Wrote about the whole thing here:
(in spanish, as usual).
12-17-2012 03:38 AM
Many thanks Dieter, I never asked for your crystal ball or expect you to waist your time, I just posted a question and you replied to it.
12-17-2012 04:29 AM
The julian date, 44712, received in the data file was an error. It was corrected later on by the vendor.
The formula I used, was posted earlier, is
SELECT CAST ( '1899-12-31' AS DATE ) + CAST ( xxxxx AS INTEGER )
Thank you all for your contributions.