PostgreSQL CURRENT DATE

Postgresql current_date

This function returns the current date.

Syntax current_date

current_date;

Example 1

postgres=# SELECT current_date;
    date    
------------
 2012-06-16
(1 row)

Related Links

• Postgresql Date and Time Functions
• Learning PostgreSQL
• Tutorial Home

---

• age
• clock_timestamp
• current_date
• current_time
• current_timestamp

• date_part
• date_trunc
• extract
• isfinite
• justify_days

• justify_hours
• justify_interval
• localtime
• localtimestamp
• now

• statement_timestamp
• timeofday
• transaction_timestamp

---