Oracle SQL - Date Time Constant Implicit Format

Introduction

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:

Demo

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';

Related Topic