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.
julian to timestamp
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
2454275,2454296.. are modified Julian day number (They start with 24...)
In PX if you use DateFromJulianDay('2454275') you will get "2007-06-23"
In PX if you use DateFromJulianDay('2454275') you will get "2007-06-23"
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 23
- Joined: Fri Mar 28, 2003 5:41 pm
- Location: USA