POSTGRESQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the CURRENT_DATE function in PostgreSQL?

How can you extract the year from a date in PostgreSQL?

What does the AGE function do in PostgreSQL?

Can you explain how the TO_CHAR function works with dates in PostgreSQL?

How does the DATE_PART function differ from the EXTRACT function in PostgreSQL?

What is the difference between CURRENT_TIMESTAMP and NOW() in PostgreSQL?

How can you calculate the difference in days between two dates in PostgreSQL?

What is the function of DATE_TRUNC in PostgreSQL and how is it used?

Explain how SET TIME ZONE affects date functions in PostgreSQL.

Describe how you can handle different date formats when importing data into PostgreSQL.