|
The SYSDATE function is used to retrieve the current database system time in Oracle and MySQL.
Oracle:
The syntax of SYSDATE in Oracle is simply
SYSDATE
It does not require any argument.
Example: The SQL statement
SELECT SYSDATE FROM DUAL;
yields the following result:
'16-JAN-2000'
MySQL:
The syntax of SYSDATE in MySQL is simply
SYSDATE()
It does not require any argument.
Example: The SQL statement
SELECT SYSDATE();
yields the following result:
'2000-01-16 09:06:22'
The SQL Server equivalent of SYSDATE is GETDATE.
SQL CREATE TABLE >>
Link to this page: If you find this page useful, we encourage you to link to this page. Simply copy and paste the code below to your website, blog, or profile.
Copyright © 2012 1keydata.com All Rights Reserved. Privacy Policy
|