Skip to contents

DuckDB function strftime

Source: R/duckdb-funs.R
strftime.Rd

Converts a date to a string according to the format string.

Arguments

data

DATE | TIMESTAMP | TIMESTAMP_NS | VARCHAR

format

VARCHAR | DATE | TIMESTAMP | TIMESTAMP_NS

Value

VARCHAR

Overloads

  • strftime(data = DATE, format = VARCHAR)

  • strftime(data = TIMESTAMP, format = VARCHAR)

  • strftime(data = TIMESTAMP_NS, format = VARCHAR)

  • strftime(data = VARCHAR, format = DATE)

  • strftime(data = VARCHAR, format = TIMESTAMP)

  • strftime(data = VARCHAR, format = TIMESTAMP_NS)

SQL examples

strftime(date '1992-01-01', '%a, %-d %B %Y')