Get a date and time right now

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

Functions

Concatenate strings

Extracting substrings

lower case

Finding Substring

Formatting numbers

Replace NULL

Conditional values

Time now

Format dates