/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

1 vote131 views1 answer
Count mysql server db tables
SQL
0 vote128 views1 answer
Subquery aggregation
SQL
2 votes77 views1 answer
Sql select in list
SQL
25 votes131 views3 answers
How to use a database to see tables mysql
SQL
0 vote121 views1 answer
Test connection to sql server
SQL
14 votes134 views3 answers
SQL trim
SQL
5 votes152 views2 answers
Postgresql add not null constraint
SQL
39 votes196 views4 answers
Select duplicates in sql
SQL
0 vote141 views2 answers
MySQL PARTITION BY month automatically
SQL
8 votes136 views2 answers
Alert table name mysql
SQL