Reference: Timestamp Functions

CedarDB supports a variety of functions for the timestamp data type. This page currently only describes a subset of those. See SQL features for a full list of supported functions.

Functions and Operators

to_char

The to_char function formats a timestamp (with or without time zone) into a string based on a user-specified format pattern.

Syntax

to_char(timestamp Timestamp, format Text) -> Text
to_char(timestamp TimestampTZ, format Text) -> Text

Examples

Formatting the release date of CedarDB with to_char to a common U.S. datetime style:

select to_char(timestamptz 'Sep 10 2025, 5:57PM+02', 'MM/DD/YYYY HH12:MI:SS PM');

        to_char
------------------------
 09/10/2025 05:57:00 PM

Format to a common German datetime style:

select to_char(timestamptz 'Sep 10 2025, 5:57PM+02', 'DD.MM.YYYY HH24:MI:SS');

      to_char
---------------------
10.09.2025 17:57:00

Supported Format Patterns

Currently, CedarDB supports a limited but commonly used subset of PostgreSQL format patterns: