SYSDATE函数

文档地址：http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions172.htm#SQLRF06124

 

SYSDATE

syntax

Description of the illustrationsysdate.gif

Purpose

SYSDATE returns the current date and time set forthe operating system on which the database resides. The datatype ofthe returned value is DATE, and the format returneddepends on the value of the NLS_DATE_FORMATinitialization parameter. The function requires no arguments. Indistributed SQL statements, this function returns the date and timeset for the operating system of your local database.You cannot use this function in thecondition of a CHECKconstraint.--这个系统时间函数是不能用于CHECK约束中的。

 

Examples

The following example returns the current operating system dateand time:

SELECT TO_CHAR
    (SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW"
     FROM DUAL;

NOW
-------------------
04-13-2001 09:45:51