Oracle Database - NLS_DATE_FORMAT

Card Puncher Data Processing

About

The parameter NLS_DATE_FORMAT control the format of the date datatype.

You can see here to see the different format possible.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';





Discover More
Obiee Database Cast Feature
OBIEE - Cast as date - Which date format to use ?

When you use the cast function to transform a character data type as a date, you may struggle with the date format that you have to give in a formula column because it depends of the configuration. ...
Obiee Filter On Date
OBIEE - Date Format in presentation variable, dashboard prompt and logical SQL

This article talk the manipulation of a presentation variable with a date datatype. Starting with OBIEE 10.1.3.4.1 and higher versions, Dashboard Prompt input formats and presentation variable values...
Card Puncher Data Processing
Oracle - Date Datatype

Use the DATE data type to store point-in-time values (dates and times) in a table. An application that specifies the time for a job might use the DATE data type. The DATE data type stores: the century,...
Card Puncher Data Processing
Oracle Database - Datatype Datetime

Oracle Database supports the following datetime data types: DATE TIMESTAMP TIMESTAMP WITH TIME ZONE TIMESTAMP WITH LOCAL TIME ZONE Use the DATE data type to store point-in-time values...
Card Puncher Data Processing
Oracle Database - Globalization (Localization, NLS parameter)

Globalization support enables the storing, processing and retrieval of data in native languages. The languages that can be stored in an Oracle database are encoded by Oracle Database-supported character...
Card Puncher Data Processing
Oracle Database - Territory (NLS_TERRITORY)

Territory in the context of oracle database. It specifies the conventions for default date, monetary and numeric formats. NLS_TERRITORY is a Nls Parameter that define the following parameters: ...
Card Puncher Data Processing
SQL Plus - Formatting Reports

How to format SQLplus output (ie ) All below parameters can be configured in the login script. Through the SQLPlus COLUMN command with the heading options, you can change the column headings...
Toad Decode Format Date 1
Toad - The date format with null and decode

When you use Toad with a date and a decode statement, you can have the surprise that two different date format appear. First Statement : Date Format :01/11/95 Second Statement : Date Format :11-01-95...



Share this page:
Follow us:
Task Runner