SQL
zoo.net
Format a date and time.
SQLite
DB2
Ingres
Access
Postgres
Oracle
SQL Server
MySQL
Mimer
Sybase
Ingres
Many engines support the SQL standard - see Mimer for details.
SELECT CAST(EXTRACT(DAY FROM wk) AS VARCHAR(2)) || '/' || CAST(EXTRACT(MONTH FROM wk) AS VARCHAR(2)) || '/' || CAST(EXTRACT(YEAR FROM wk) AS VARCHAR(4)), song FROM totp WHERE singer='Tom Jones'
Specific to Ingres
none
Related links:
DATES
Date and time types.
Format a date and time.
Specify a date (date literal).
Match a range of dates
Subtract dates.
Add days to a date. INTERVALS. Also subtract, also years, months, hours ...
Components of a date: such as the year or the month
Group by day of the week (using date functions)
Group by day of the week (using arithmetic)
How can I select the oldest person in the table PERSON by birthday?
Select a record with the latest date
How to format a date like yyyymmdd
How can I get the Lastest record from SQL
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.