TO_TIMESTAMP

to_timestamp(expr [, fmt])

Description

The TO_TIMESTAMP function is used to convert different types of date-time expressions (expr) into a timestamp type. If the fmt parameter is provided, the function will parse according to the specified format; if fmt is not provided, it will convert according to the default format. If the date-time format in expr is incorrect, the function will return null.

Parameter Description

• expr (string): The string expression to be converted.
• fmt (string, optional): Specifies the format of the date-time in the string expression.

Return Result

The converted timestamp.

Usage Example

1. Convert a string to a timestamp (without specifying the fmt parameter):

   SELECT to_timestamp('2022-02-01 10:23:32.121') as res; +-------------------------+ | res | +-------------------------+ | 2022-02-01 10:23:32.121 | +-------------------------+

2. Convert the string to a timestamp according to the specified format:

   SELECT to_timestamp('2022/02/01 10:23:32.121', 'yyyy/MM/dd HH:mm:ss.SSS') as res; +-------------------------+ | res | +-------------------------+ | 2022-02-01 10:23:32.121 | +-------------------------+

3. Convert different types of date-time strings to timestamps:

   SELECT to_timestamp('01-02 10:23:32', 'dd-MM HH:mm:ss') as res; +---------------------+ | res | +---------------------+ | 1970-02-01 10:23:32 | +---------------------+

4. Convert illegal date-time strings:

   SELECT to_timestamp('2022-02-30 10:23:32.121') as res; +-----+ | res | +-----+ | | +-----+

Please note that the TO_TIMESTAMP function will return null when processing illegal date-time strings. Therefore, when using this function, ensure that the input string format is correct. Additionally, you can flexibly handle date-time strings in different formats through the fmt parameter.