Home > 11g > Few points on Date datatype.

Few points on Date datatype.

April 24, 2013

General points on date datatype.

1) The default date format for an Oracle Database date value is derived from the NLS_DATE_FORMAT and NLS_DATE_LANGUAGE initialization parameters.

2) If you specify a date value without a time component, then the default time is midnight.

3) If you specify a date value without a date, then the default date is the first day of the current month.

4) The default date format for the TIMESTAMP WITH TIME ZONE datatype is determined by the value of the NLS_TIMESTAMP_TZ_FORMAT initialization parameter.

 

For more information, Please refer to below URL.

http://docs.oracle.com/cd/B28359_01/server.111/b28298/ch4datetime.htm

Advertisements
Categories: 11g
%d bloggers like this: