{"id":2446,"date":"2025-03-15T15:13:36","date_gmt":"2025-03-15T08:13:36","guid":{"rendered":"https:\/\/www.pgtutorial.com\/?page_id=2446"},"modified":"2025-03-21T20:20:11","modified_gmt":"2025-03-21T13:20:11","slug":"postgresql-current_date","status":"publish","type":"page","link":"https:\/\/www.pgtutorial.com\/postgresql-date-functions\/postgresql-current_date\/","title":{"rendered":"PostgreSQL CURRENT_DATE"},"content":{"rendered":"\n

Summary<\/strong>: In this tutorial, you’ll learn how to get the current date using the PostgreSQL CURRENT_DATE<\/code> function.<\/p>\n\n\n\n

PostgreSQL CURRENT_DATE Function Overview #<\/a><\/h2>\n\n\n\n

The CURRENT_DATE<\/code> function retrieves the current date based on the server’s time zone and system clock. It is useful for filtering records, performing date calculations, and tracking time-sensitive data.<\/p>\n\n\n\n

The syntax of the CURRENT_DATE<\/code> function is straightforward:<\/p>\n\n\n

CURRENT_DATE<\/span><\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
The CURRENT_DATE<\/code> function does not require parentheses ()<\/code> or parameters.<\/p>\n\n\n\n
Getting the Current Date of the Server #<\/a><\/h2>\n\n\n\n
Step 1<\/strong>: Show the current timezone of the server<\/p>\n\n\n
SHOW<\/span> TIMEZONE;<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
Step 2<\/strong>: Use the CURRENT_DATE<\/code> function to get the current date<\/p>\n\n\n
SELECT<\/span> CURRENT_DATE<\/span>;<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
Inserting the Current Date into a Table Column #<\/a><\/h2>\n\n\n\n
To insert the current date into a date column, use the CURRENT_DATE<\/code> function. For example:<\/p>\n\n\n
INSERT<\/span> INTO<\/span>\n  transactions (\n    product_id,\n    warehouse_id,\n    user_id,\n    type<\/span>,\n    quantity,\n    transaction_date\n  )\nVALUES<\/span>\n  (1<\/span>, 1<\/span>, 1<\/span>, 'receipt'<\/span>, 10<\/span>, CURRENT_DATE<\/span>),\n  (2<\/span>, 1<\/span>, 1<\/span>, 'receipt'<\/span>, 20<\/span>, CURRENT_DATE<\/span>)\nRETURNING<\/span>\n  *;<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
Filtering Records Based on the Current Date #<\/a><\/h2>\n\n\n\n
Retrieve transactions that occur today using the CURRENT_DATE<\/code> function:<\/p>\n\n\n
SELECT<\/span>\n  *\nFROM<\/span>\n  transactions\nWHERE<\/span>\n  transaction_date = CURRENT_DATE<\/span>;<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
Setting a Default Value for a Table Column #<\/a><\/h2>\n\n\n\n
You can set a default value<\/a> for a date column using the CURRENT_DATE<\/code> function. For example:<\/p>\n\n\n
CREATE<\/span> TABLE<\/span> tasks (\n  task_id INT<\/span> GENERATED<\/span> ALWAYS<\/span> AS<\/span> IDENTITY<\/span> PRIMARY KEY<\/span>,\n  task_name VARCHAR<\/span>(255<\/span>) NOT<\/span> NULL<\/span>,\n  completed BOOL<\/span> DEFAULT<\/span> FALSE<\/span>,\n  completion_date DATE<\/span> DEFAULT<\/span> CURRENT_DATE<\/span>\n);<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
When inserting a row<\/a> without specifying a value for the completion_date<\/code> column, PostgreSQL automatically fills it with the current date:<\/p>\n\n\n
INSERT<\/span> INTO<\/span>\n  tasks (task_name)\nVALUES<\/span>\n  ('Learn the CURRENT_DATE function'<\/span>)\nRETURNING<\/span>\n  task_name,\n  completed,\n  completion_date;<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
            task_name            | completed | completion_date\n---------------------------------+-----------+-----------------<\/span>\n Learn the CURRENT_DATE<\/span> function<\/span> | f         | 2025<\/span>-03<\/span>-15<\/span><\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
Calculating Date Differences #<\/a><\/h2>\n\n\n\n
You can use CURRENT_DATE<\/code> to calculate date differences. For example:<\/p>\n\n\n\n
Step 1<\/strong>: Insert a row<\/a> into the tasks<\/code> table<\/p>\n\n\n
INSERT<\/span> INTO<\/span>\n  tasks (task_name, completion_date)\nVALUES<\/span>\n  ('Master PostgreSQL'<\/span>, '2025-03-31'<\/span>);<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
Step 2<\/strong>: Calculate the number of days to complete a task (assuming today is March 15, 2025)<\/p>\n\n\n
SELECT<\/span>\n  task_name,\n  completion_date - CURRENT_DATE<\/span> AS<\/span> days\nFROM<\/span>\n  tasks;<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
            task_name            | days\n---------------------------------+------<\/span>\n Learn the CURRENT_DATE<\/span> function<\/span> |    0<\/span>\n Master PostgreSQL               |   16<\/span><\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
Summary #<\/a><\/h2>\n\n\n\n
Try it<\/a><\/p>\n\n\n\n
Try it<\/a><\/p>\n\n\n\n
Try it<\/a><\/p>\n\n\n\n
Try it<\/a><\/p>\n\n\n\n
Try it<\/a><\/p>\n\n\n\n
Try it<\/a><\/p>\n\n\n\n