Common functions of Oralce SQL language (3) date functions

Common functions in Oralce SQL language (3) DATE functions operate data of the DATE type. Most of its input parameters are of the DATE type, and the output parameters are also of the DATE type 1. SYSDATE function. This function does not require any parameters, returns the current system time. It looks more like a keyword www.2cto.com. The returned time format is related to the language selected during Oracle Installation. It is automatically matched to the standard time format used in the current region, for example, select sysdate from dual. you can obtain the standard time format of the current region for display. Note that it cannot be used with parentheses. the EXTRACT function is used to return partial date values of a date. The example is as follows:
Example 2: Search the product table and display the shelving time in the year-month-day format.