answersLogoWhite

0

What is the Oracle date format used for?

Updated: 8/20/2019
User Avatar

Wiki User

10y ago

Best Answer

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.

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the Oracle date format used for?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

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.


What is the date format in Oracle?

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


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.


What is gm date in php?

Gm date is used to return date and time in UTC/GMT format.


What does OA date means?

OA Date means a date stored on a computer in OLE Automation format. This format stores the date in 4 bytes and is used by a large array of Microsoft and other software on Windows.


What font is used for the oracle logo?

Oracle


Where were oracle bones used to predict the future?

Oracle bones were used in China.


How to get the date difference in oracle?

by using months_between() function


Where can one find online tutorials about using string format?

The string format used in C/C++ programming as well as JAVA is covered in many online tutorials. Both Microsoft and Oracle have sections dedicated to programming tutorials.


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 oracle pft?

Oracle PFT = Oracle Profitability Manager which is a tool used in the financial end.


What can oracle forms be used for?

Oracle forms are part of a programming language and are used to deploy oracle forms. These are used by developers creating apps for the Android operating system.