/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 vote289 views3 answers
How to run sql query
SQL
0 vote319 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote333 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
8 votes313 views1 answer
Mysql limit rows
SQL
0 vote280 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote291 views1 answer
Migration graphql
SQL
0 vote254 views1 answer
Select other columns with distinct
SQL
0 vote285 views1 answer
How to add timestamp column in mysql
SQL
2 votes279 views1 answer
Mysql change data type of column
SQL
1 vote257 views1 answer
Stop mysql server mac
SQL