/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 vote148 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote186 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote148 views1 answer
Sql select with apostrohpe
SQL
0 vote149 views1 answer
Contact mysql column field
SQL
0 vote149 views1 answer
Typeorm raw sql
SQL
0 vote131 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote164 views2 answers
Select last 30 days sql
SQL
1 vote139 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
3 votes148 views1 answer
Mysql UPDate with enner join
SQL
5 votes226 views1 answer
Oracle source query
SQL