PostgreSQL Date And Time Part 2


In this article, we will cover the most commonly used PostgreSQL date and time functions: LOCALTIMESTAMP(), LOCALTIME(), TO_DATE(), TO_TIMESTAMP(). If you are not yet familiar with any date and time functionality my suggestion would be to go through Part  1 of this PostgreSQL Date And Time tutorial series to get started.


The LOCALTIMESTAMP() function returns the current date and time without the local time zone. The function takes an optional argument, called precision. The basic syntax is:


The results of the first half of the output depict the date followed by time in 24hr format. Since