How to insert current date in postgresql?

Question

Navigation

#1 by (4 votes)
#2 by (1 votes)

4

I need to set in a column in postgresql the current date of the insertion as default value for the field.

How can I do this?

sql data postgresql

asked by anonymous 27.09.2016 / 21:13

2 answers

1

alter table minha_table
alter column minha_date set default current_timestamp

create table minha_table
(
    minha_date  date not null default CURRENT_DATE
);

(CURRENT_DATE is basically a synonym for now() and a cast to date).

28.09.2016 / 15:25

Save latitude and longitude in swift Obfuscate CSS and JavaScript for free

score 4 · Accepted Answer

4

You can set the default value for column creation, for example:

my_date date not null default CURRENT_DATE

28.09.2016 / 11:20