SQLzoo.net

Format a date and time.

Related links:

• 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

• 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.