This implicit conversion depends on the NLS_DATE_FORMAT and NLS_TIMESTAMP_FORMAT parameter settings for your session.
To see an overview of all current NLS parameter settings for your session, you can use the following query:
SQL> SQL> select * from nls_session_parameters; PARAMETER-- w w w . j a v a2 s . com -------------------------------------------------------------------------------- VALUE -------------------------------------------------------------------------------- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ ... 17 rows selected. SQL>
To change format
alter session set NLS_DATE_FORMAT = 'dd Month yyyy hh24:mi:ss';