/SQL/Postgresql create table default value timestamp

Postgresql create table default value timestamp

CREATE TABLE `table_name`(
	`id` SERIAL PRIMARY KEY,
	`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`modified_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
)

Similar codes

0 vote165 views1 answer
Compare subqueries oracle
SQL
0 vote153 views1 answer
Zerar auto increment mysql
SQL
0 vote186 views1 answer
Composit key in sql
SQL
2 votes173 views1 answer
How to get weekday from old date in sql
SQL
0 vote168 views1 answer
Why we have to set the password for my sql server
SQL
0 vote216 views1 answer
Which lock mode is not available in sql
SQL
2 votes165 views1 answer
Cast string to datetime mysql
SQL
6 votes185 views4 answers
Mysql group by month
SQL
32 votes204 views6 answers
Rename column mysql
SQL
1 vote168 views1 answer
Sqlalchemy order by descending
SQL