Category: Oracle PL/SQL

Bookmark and Share

Date functions: CURRENT_DATE - The CURRENT_DATE function returns the current date in the session time zone as ...
Date Functions: DUMP - DUMP returns a VARCHAR2 value containing the datatype code, length in bytes, and the int...
Date Functions: EXTRACT - Extracts and returns the value of a specified datetime field from a datetime or inter...
Date Functions: GREATEST - Returns the latest date value.
Date Functions: INTERVAL - Interval to adjust date-time.
Date Functions: LAST_DAY - Returns the last date (not day) of a given month.
Date Functions: LEAST - Returns the earliest date.
Date Functions: LENGTH - Returns length in characters.
Date Functions: LENGTHB - Similar to LENGTH, but returns the length in bytes.
Date Functions: MAX - Returns the latest date.
Date Functions: MIN - Returns the earliest date.
Date Functions: MONTHS_BETWEEN - Returns the months in between (separating) two given dates.
Date Functions: NEW_TIME - Returns the date and time in time zone zone2 when date and time in time zone zone1 a...
Date Functions: NEXT_DAY - Gives you the date of next specified date following a given date.
Date Functions: NUMTODSINTERVAL - Converts a number to an INTERVAL DAY TO SECOND literal.
Date Functions: NUMTOYMINTERVAL - Converts n to an INTERVAL YEAR TO MONTH literal.
Date Functions: Return next date - Takes a date and returns the next date, a simple skeleton for date functions.
Date Functions: ROUND - Returns date rounded to the unit specified by the format model. If you omit the format,...
Date Functions: Round (date) - The round function returns a date rounded to a specific unit of measure
Date Functions: SYSDATE - Returns the current date and time set for the operating system on which the databa...
Date Functions: TO_CHAR - Converts DATE and TIMESTAMP to VARCHAR2 with the specified format.
Date Functions: To_Date - The to_date function converts a string to a date.
Date Functions: TO_DSINTERVAL - Converts a string to an INTERVAL DAY TO SECOND DataType.
Date Functions: TO_NCHAR - Converts a DATE or TIMESTAMP from the database character set to the National Charac...
Date Functions: TO_YMINTERVAL - Converts a string to an Interval Year to Month data type.
Date Functions: TRUNC - Convert a date to the date it would be at midnight. Using the option with TRUNC for...
Date Functions: TRUNC (date) - The trunc function returns a date truncated to a specific unit of measure.
Date Functions: WHERE Clause Joins - Examples of using dates in WHERE Clause Joins.
Date Math Sample 1 - An example of subtracting dates to get the difference between them.
Date/Time Calculations: Get seconds between dates - Calculates the number of seconds between two given date-tim...

© | users online: 6