/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 vote149 views1 answer
Sql max min
SQL
3 votes146 views1 answer
Two select sql
SQL
1 vote392 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote145 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
1 vote147 views1 answer
Generate random data postgresql
SQL
8 votes147 views1 answer
Oracle search source code
SQL
4 votes978 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
1 vote144 views1 answer
Update from select join
SQL
0 vote154 views1 answer
Java nosql sort
SQL
32 votes144 views6 answers
Insert select
SQL