In this article, we will see how to get current date in PostgreSQL. We can get current date in PostgreSQL by running the command current_date. Which gives output as YYYY-MM-DD(Year-month-day of month).
If we want to get date with time, we have to use now() function and if we want to see timezone, we use the command show timezone