Get a date and time right now
From SQLZoo
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