PL/SQL (MOSC)

MOSC Banner

fractional seconds in to_utc_timestamp_tz?

in PL/SQL (MOSC) 2 commentsAnswered ✓

Hi,

We're on Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production and it seems that fractional seconds are not supported in to_utc_timestamp_tz. The following select gives an ORA-01858 "a non-numeric character found where a digit was expected":

select to_utc_timestamp_tz('2000-01-02T12:34:56.789') from dual;

Without the fractional seconds it does work. The format of the datetime-string is specified as

YYYY-MM-DDThh:mm:ss[.s[s[s[s[s[s]]]]][Z|(+|-)hh:mm]

so I expected this to work.

Am I doing something wrong? If not, is this a known bug (I couldn't find one) or should I file a new one?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center