Which date function returns number value in Oracle?
Which date function returns number value in Oracle? Returns the current date as a value in ' YYYY-MM-DD ' or YYYYMMDD format, depending on whether the function is used in string or numeric context....Table 12.11 Date and Time Functions.NameDescriptionCURDATE()Return the current dateCURRENT_DATE() , CURRENT_DATESynonyms for CURDATE() What is the Oracle date format? Oracle date format The standard date format for input and output is DD-MON-YY e.g., 01-JAN-17 which is controlled by the value of the NLS_DATE_FORMAT parameter. The following statement returns the current date with the standard date format by using the SYSDATE function. How are dates stored in Oracle...