julian to timestamp

attu · Post by **attu** » Mon Jun 04, 2007 3:38 pm

how to convert 2454282 julian date to timestamp yyyy-mm-dd- 00:00:00
i am using basic transformer and
Oconv(Iconv(InLink.InputColumn, "DYJ"), "D-YMD[4,2,2]"):'00:00:00'.
what kind of julian dates are they 2454275,2454296?
any help is appreciated thanks.

JoshGeorge · Post by **JoshGeorge** » Mon Jun 04, 2007 7:09 pm

2454275,2454296.. are modified Julian day number (They start with 24...)

In PX if you use DateFromJulianDay('2454275') you will get "2007-06-23"

ray.wurlod · Post by **ray.wurlod** » Tue Jun 05, 2007 1:58 am

Julian is an abused term roughly meaning "counted from a particular day zero".

attu · Post by **attu** » Tue Jun 05, 2007 9:03 am

Thanks Ray and Josh...

The julian date is coming as an integer and the expected result is a timestamp date.
2007-04-22 00:00:00

I would be using Datefromjulianday but the date coming is an integer?
how would i transform that.

Any thoughts
Thanks

ray.wurlod · Post by **ray.wurlod** » Wed Jun 06, 2007 1:11 am

The integer that's coming in is the "Julian day" expected by the function. It is the number of days since "day zero".

Ed Purcell · Post by **Ed Purcell** » Wed Jun 06, 2007 12:38 pm

OK, so what should we do if the Julian date comes in as a character string, say, "2007128"?

DSguru2B · Post by **DSguru2B** » Wed Jun 06, 2007 12:49 pm

Cast it As Integer using that function in the transformer stage.