so i got this date formatted from one of my tables:
select to_char(a_timestamp_field, 'yyyy/mm/dd:hh:mi:ss.ff') (the date field is timestamp(3))
it returns this date:
4638/01/01:12:00:33.690
but when I try to format that into a date using the same format:
where some_timestamp(3)_field = to_date('4638/01/01:12:00:33.690','yyyy/mm/dd:hh:mi:ss.ff3')
I get an error:
SQL Error: ORA-01821: date format not recognized
I thought I was using the same format I used to get a result to format the result into a date to use
in a new query, I just changed the 'ff' to 'ff3' to let the format function know i am sending 3 chars for the fraction of a second
can't find whats wrong with this