/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 vote317 views1 answer
Mysql monthname
SQL
0 vote323 views2 answers
SQL BULK INSERT
SQL
10 votes414 views4 answers
Sql server pagination
SQL
0 vote322 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
15 votes332 views1 answer
Mysql int range
SQL
0 vote327 views1 answer
How to fetch unique records from two tables
SQL
0 vote338 views1 answer
Enable sql server full text indexing
SQL
0 vote342 views1 answer
Update sql sintax
SQL
0 vote332 views1 answer
Mysql join column order By and group By
SQL
0 vote331 views2 answers
Create fulltext index mysql
SQL