SQLzoo.net

Get the current date and/or time

Access
SQL Standard specifies CURRENT_TIMESTAMP, CURRENT_DATE and CURRENT_TIME. These are widely ignored :(	Execute set up code DROP TABLE nix; CREATE TABLE nix (id int); INSERT INTO nix VALUES (1) SELECT Now(), Date(), Time() FROM nix
Specific to Access
none