Could you please help me with a query with which i can convert a date value (YYYY-MM-DD) in to julian date format YYYYDDD.
You can cast it like this:
Thanks a lot for your input, however i didnt get the same result while executing the query. In fact the format appears as 2014-09-07 as mentioned below. Am i doing something wrong here, please advice.
SELECT CURRENT_DATE (DATE, FORMAT 'YYYYDDD');
Jerico ... thanks a lot again ... found below query to work as expected.
select current_date (format 'yyyyddd') (char(7));