convert julian date to normal date
$sidAug 3 2012 — edited Aug 6 2012Hi All,
I am using TO_DATE(TO_CHAR(datecolumn+1900000),'YYYYDDD') sql query to convert julian date format to normal date format
it is working fine for all the date format attributes like start date, hiredate, end date except date of birth attribute
I have a date of birth attribute for this same query is not working
Can i know the soluiton
Error report:
SQL Error: ORA-01848: day of year must be between 1 and 365 (366 for leap year)
01848. 00000 - "day of year must be between 1 and 365 (366 for leap year)"
*Cause:
*Action:
Regards
user7609