'FF3' in to_timestamp function
Sateesh Kumar Arvapalli, October 17, 2019 - 4:17 pm UTC
Thanks Tom for confirming on bug about 'FF#' usage in to_timestamp function. We had similar issue & overcame by using 'FF' in our program.
FYI - we are on "Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production"- unlike youmentioned in above comment the issue is fixed in 12c, but we still see issue the with 'FF3'
'FF3' in to_timestamp function
Sateesh Kumar Arvapalli, October 17, 2019 - 4:18 pm UTC
hanks Tom for confirming on bug about 'FF#' usage in to_timestamp function. We had similar issue & overcame by using 'FF' in our program.<br>
FYI - we are on "Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production"- unlike you mentioned in above comment the issue is NOT fixed in 12c, but we still see issue the with 'FF3'
October 21, 2019 - 6:24 am UTC
Not sure what you mean by "still see the issue with FF3".
FF3 should *not* work, it *should* return a ora-01830.
That is what we fixed in 12c.