SQL
zoo.net
Get the current date and/or time
SQLite
DB2
Access
Postgres
Oracle
SQL Server
MySQL
Mimer
Sybase
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 CURRENT_TIMESTAMP, CURRENT_DATE, CURRENT_TIME FROM nix
Specific to
none
Related links:
FUNCTIONS
Concatenate strings.
Substring: Extracting part of a string.
lower case
Finding a substring in a string
Formatting numbers to two decimal places.
Replace a NULL with a specific value
Conditional values
Get the date and time right now.
Format dates.