Skip to content

ToChar

Basic information

Object type functions.ToChar
Since 0.4.0
Dialects PostgreSQL

Object attributes

Attribute Accepts Required
obj functions.ToChar True
property functions.* Property Constant CastOperator Interval True
format String True
alias String False

JSON format

{
  "obj": "functions.ToChar",
  "property": {
    "obj": "properties.Property",
    "name": "users.created_at"
  },
  "format": "HH12:MI:SS",
  "alias": "formatted_datetime"
}

SQL

to_char(users.created_at, 'HH12:MI:SS') AS formatted_datetime