Get a date and time right now

From SQLZOO
Revision as of 16:06, 17 July 2012 by Connor (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Get the current date and/or time

schema:gisq

SQL Standard specifies CURRENT_TIMESTAMP, CURRENT_DATE and CURRENT_TIME. These are widely ignored :(

 
 
SELECT Now(), DATE(), TIME()
 FROM nix
SELECT GETDATE()
 FROM nix
SELECT SYSDATE, SYSTIMESTAMP 
 FROM gisq.nix
SELECT CURRENT_TIMESTAMP, CURRENT_DATE, CURRENT_TIME
 FROM nix
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense