The timestamp data type is more readable. In our example, the text date and time ' 7/15:23:45'was converted to the timestamp value 15:23:45+02. The function TO_TIMESTAMP() returns a timestamptz value with time zone information. Notice that the input format is a string. You can find a complete list of datetime pattern elements in the PostgreSQL documentation. ![]() Note that we use slashes (/) as date part delimiters and colons (:) as time part delimiters.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |