Date conversions

Jay · Post by **Jay** » Tue Jan 18, 2005 9:38 am

Hi All,

How do i convert a date in Oracle 9i Timestamp format to an Oracle 9i date in YYYYDDD format ?

Without iconv/oconv i am running out of ideas....i tried the TimestampToDate...but i have not been successful so far...

Thanks in advance
Jay

ray.wurlod · Post by **ray.wurlod** » Tue Jan 18, 2005 3:29 pm

How about converting it with a TO_CHAR function in the original SQL that extracts it from the table?

Jay · Post by **Jay** » Tue Jan 18, 2005 5:17 pm

That is what i did....

i have the input string in YYYYDDD format and

target is a date in YYYYDDD format....

how do i do the reverse...something like a to_date()....will it work if i do a to_date() in the insert/ update statements....

problem is i cannot test it...i am getting that darn "Oracle does not exist" error...

i was thinking maybe because of the mismatch in metadata, i might be getting the error or it actually is a config/path error.....

Jay · Post by **Jay** » Tue Jan 18, 2005 5:18 pm

Anyways, thanks for your time, Ray...

T42 · Post by **T42** » Wed Jan 19, 2005 7:20 pm

Why not StringToDate(TimeStampToString())? You will need a Left() or something within there somewhere to truncate the output from TimeStampToString().