PostgreSQL Date And Time Part 2

 dans Sites anglophones  étiqueté Date Functions / PostGreSQL par

Overview

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.

LOCALTIMESTAMP()

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:

SELECT LOCALTIMESTAMP;

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