/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 vote246 views1 answer
How to query all tables mysql at the same time
SQL
2 votes271 views2 answers
Postgres trigger insert into another table
SQL
0 vote251 views1 answer
What is between operator
SQL
0 vote247 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
2 votes279 views3 answers
Sql server: how to concatenate column data using comma
SQL
34 votes273 views5 answers
Oracle alter table add column
SQL
0 vote266 views4 answers
Mysql desactivar trigger
SQL
0 vote261 views1 answer
Import excel to sql
SQL
5 votes263 views1 answer
Oracle get foreign keys on table
SQL
1 vote261 views2 answers
Postgres cast as decimal
SQL