About Date and Time Formats

Different countries have different conventions for displaying the hour, day, month, and year. For example:

Country	Date Format	Example	Time Format	Example
China	`yyyy-mm-dd`	`2005-02-28`	`hh24:mi:ss`	`13:50:23`
Estonia	`dd.mm.yyyy`	`28.02.2005`	`hh24:mi:ss`	`13:50:23`
Germany	`dd.mm.rr`	`28.02.05`	`hh24:mi:ss`	`13:50:23`
UK	`dd/mm/yyyy`	`28/02/2005`	`hh24:mi:ss`	`13:50:23`
U.S.	`mm/dd/yyyy`	`02/28/2005`	`hh:mi:ssxff am`	`1:50:23.555 PM`

Related Topics

About the NLS_DATE_FORMAT Parameter

About the NLS_DATE_LANGUAGE Parameter

About the NLS_TIMESTAMP_FORMAT and NLS_TIMESTAMP_TZ_FORMAT Parameters

Oracle Database Globalization Support Guide

Oracle Database SQL Language Reference

About Globalization Support Features