SQL STRFTIME()

The STRFTIME() function returns a formatted date, as specified in a format string.

Syntax

STRFTIME(format, timestring, modifier1, modifier2, ...)

Copy to clipboard
Copy to clipboard

• format is the format string.
• timestring is the column or the original value.
• The remaining arguments are 0 or more optional modifiers to transform the time string.

The substitutions to extract each part of the date and time are the following:

• %Y returns the year (YYYY)
• %m returns the month (01-12)
• %d returns the day of month (01-31)
• %H returns the hour (00-23)
• %M returns the minute (00-59)
• %S returns the second (00-59)

Example

For example, suppose there’s a bodega table with the following data:

SELECT order_date,
  STRFTIME('%H', order_date)
FROM bodega;

Copy to clipboard
Copy to clipboard

This would return the time for the order_date column.