Postgres Pro
Downloads
Home   >   mailing lists

Default for date field: today vs CURRENT_DATE - Mailing list pgsql-general

From Rich Shepard
Subject Default for date field: today vs CURRENT_DATE
Date
Msg-id alpine.LNX.2.20.1901021343520.20959@salmo.appl-ecosys.com
Whole thread Raw
Responses Re: Default for date field: today vs CURRENT_DATE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
   Reading the manual I saw that 'today' is a special value, but it did not
work when I used it as a column default; e.g.,
start_date date DEFAULT today,

   Appending parentheses also failed. But, changing today to CURRENT_DATE
worked. I've not found an explanation and would appreciate learning why
'today' fails.

TIA,

Rich

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Implementing standard SQL's DOMAIN constraint [RESOLVED]
Next
From: Tom Lane
Date:
Subject: Re: Default for date field: today vs CURRENT_DATE