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