Date functions perform specific operations regarding date information. These functions enter or alter a date in a particular manner. The date functions are summarized in the table below. Click on the function name to jump to a discussion of that function.
Function |
|
Returns a date string or the current date. |
|
Converts one date format to a new format and returns the result. |
|
Adds days, months, and years to the date and returns the result. |
|
Converts a date specified with a two-digit year into a date containing a four-digit year value. |
|
Returns the day of the month number from a date and returns the result. |
|
Returns the specified day name. |
|
Returns the number of days in the specified month and year. |
|
Returns the number of days in the specified year. |
|
Calculates the difference between two dates and returns a positive or negative value based on which date is earlier. |
|
Returns the difference in days between two dates. |
|
Returns the difference in months between two dates. |
|
Returns the difference in years between two dates. |
|
Returns one (1) if the specified year is a leap year and zero (0) if it is not a leap year. |
|
Returns the month number from a date. |
|
Returns the specified month name. |
|
Returns the week day number from a date. |
|
Returns the year from a date. |
|
Returns the number of the day of the year from a date. |
Before we examine each date function individually you must understand the available date formats. Date formats are usually one of the parameters you enter for a date function. The date format determines how your date information appears when it is returned to the section assigned to a target variable.
© Copyright 2014, Oracle and/or its affiliates. All rights reserved. Legal notices.