1Keydata.com

SQL SYSDATE Function


  SQL > SQL Commands > Sysdate Function

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.


More 1Keydata Tutorials
Data Warehousing:   Data Modeling   Business Intelligence   Data Integrity   Star Schema   Logical Data Model
CSS Tutorial:   CSS Background   CSS Border   CSS Padding   CSS Overflow   CSS Margin   CSS Cursor
PHP Tutorial:   PHP Foreach   PHP Redirect   PHP Array   PHP Include   PHP Explode   PHP For Loop   PHP Substr
HTML Tutorial:   Radio Button   HTML Checkbox   HTML Drop Down   Basic HTML Tags   Text Input   Color Codes


Copyright © 2012   All Rights Reserved.     Privacy Policy  



SQL SELECT
SQL DISTINCT
SQL WHERE
SQL AND OR
SQL IN
SQL BETWEEN
SQL Wildcard
SQL LIKE
SQL ORDER BY
SQL Functions
SQL Average
SQL COUNT
SQL MAX
SQL MIN
SQL SUM
SQL GROUP BY
SQL HAVING
SQL ALIAS
SQL AS
SQL JOIN
SQL INNER JOIN
SQL OUTER JOIN
SQL LEFT OUTER JOIN
SQL CROSS JOIN
SQL SELECT UNIQUE
SQL CONCATENATE
SQL SUBSTRING
SQL TRIM
SQL LENGTH
SQL REPLACE
SQL DATEADD
SQL DATEDIFF
SQL DATEPART
SQL GETDATE
SQL SYSDATE

SQL CREATE TABLE
SQL CONSTRAINT
SQL NOT NULL
SQL DEFAULT
SQL UNIQUE
SQL CHECK
SQL PRIMARY KEY
SQL FOREIGN KEY
SQL View
SQL CREATE VIEW
SQL Index
SQL CREATE INDEX
SQL ALTER TABLE
SQL DROP TABLE
SQL TRUNCATE TABLE
SQL USE
SQL INSERT INTO
SQL UPDATE
SQL DELETE FROM

SQL Jobs

Site Map
Resources