to_timestamp(src text, format text)

Let us now check the to_timestamp(date,format) function with the following query.

Query

default> select to_timestamp(412312345);  

Result

The above query will generate the following result.

1983-01-25 03:12:25 

The query converts to timestamp.