FORMATDATETIME

Syntax

FORMATDATETIME(date, format)

Purpose

The FORMATDATETIME function takes a date or date-time expression date and a format string format and returns a string that represents date in the specified format. For example, FORMATDATETIME(date, '%Y-%m-%d %H:%i:%s').

Examples

1. Enable the ClickHouse extension function mode.

   obclient> ALTER SYSTEM SET sql_func_extension_mode = "ClickHouse";
   

2. Format the current date and time into the YYYY-MM-DD HH:MI:SS format.

   obclient> SELECT FORMATDATETIME(NOW(), '%Y-%m-%d %H:%i:%s') AS formatted_date;
   

   The return result is as follows:

   +---------------------------------+
   | formatted_date                  |
   +---------------------------------+
   | March 30, 2026 10:44:53     |
   +---------------------------------+
   1 row in set