Thanks for the question, Federico.
Asked: October 03, 2016 - 1:19 pm UTC
Last updated: October 04, 2016 - 11:27 am UTC
Version: 4.0.1.14
Viewed 1000+ times
You Asked
Hi,
i need to convert a julin number in 'my_fiel'
ODI enviroment
I've in source DECIMAL >>> target DATE.
i've tryed many query but i'don't to got fix my problem.
select
to_date(to_char(s'MyField','J'),'yyyy-mm-dd')
from dual
can you help me? Thx
and Connor said...
I'm not sure what you mean. If the input data is julian, you can use the same format mask to convert into a date, eg
SQL> select to_char(sysdate,'J') from dual;
TO_CHAR
-------
2457666
SQL> select to_date('2457666','J') from dual;
TO_DATE('
---------
04-OCT-16
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment