answersLogoWhite

0

The default date format can be set at the database level. The default in the USA is:

DD-MON-YYYY

e.g. 01-JAN-2012

This format will also accept a lowercase month name, such as 01-jan-2012.

Best practice is to always provide an explicit date format for any conversion:

l_date_string VARCHAR2(16) := TO_CHAR(SYSDATE, 'DD-MON-YYYY');

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is the Oracle date format used for?

Oracle date format is used in computer programming. Some applications require a date and/or the time be included. Oracle supports date and time in one entity which is different from other SLQ2 standards which use both date and time as separate entities.


What is the format used for the date?

Oracle date format is used in computer programming. Some applications require a date and/or the time be included. Oracle supports date and time in one entity which is different from other SLQ2 standards which use both date and time as separate entities.


How to get the date difference in oracle?

by using months_between() function


What does ccyy mean?

It is a date format showing the full year and century, ie 2008 where CC is 20 and YY is 08. this is true everyehwere but in Oracle where the CCYY would yield 2108 as 2008 is the 21st centruy.


What is the Mexican passport date format?

The Mexican passport date format is day-month-year.


What is Javadoc from Oracle Corporation used for?

Javadoc from Oracle Corporation is used for generating API documents in HTML format. These documents can be viewed and edited online by anyone who is given access to them.


In MLA format, do you include the due date in your paper?

No, in MLA format, you do not include the due date in your paper.


How do you change date format?

go to the command prompt and give the date commandusing the proper format and then restart the computer


Do you need the date accessed in MLA format?

Yes, the date accessed is required in MLA format for online sources.


How to date a paper in MLA format?

To date a paper in MLA format, you should include the date on the top right corner of the first page. The date should be written in the day month year format (e.g., 12 March 2022).


What date do you put on an MLA format document?

In MLA format, you typically put the date on the top right corner of the document. The date should be written in the day month year format, such as 12 March 2023.


What is the date format for a Mexico passport?

The date format for a Mexico passport is day-month-year (DD-MM-YYYY).