Wednesday , April 24 2024

PostgreSQL Date Functions

In today’s article, we will be learning the most commonly used PostgreSQL date functions that allow you to effectively change date and time values.

AGE():It shows the day, month and year differences between two dates.

CURRENT DATE:It gives the date information at the time it was run.

CURRENT_TIME:It gives the time information at the time it was run.

DATE_PART():It is used to print the day, month and year parameters of the specified date.

Finding the difference between two times with the date_part method.

EXTRACT():It is similar to the DATE_PART() function.

ISFINITE():Date formats etc. used for testing.

DATE_TRUNC():It is used to reset the specified date as year, month and day.


About Faruk Erdem

Leave a Reply

Your email address will not be published. Required fields are marked *