/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

8 votes165 views4 answers
Mysql update one table from another table multiple columns
SQL
1 vote170 views3 answers
Mysql disable foreign keys check
SQL
0 vote166 views1 answer
Difference between varchar and varchar2
SQL
4 votes161 views1 answer
To date oracle with time
SQL
16 votes181 views6 answers
Install sqlite3 python
SQL
2 votes168 views1 answer
Mysql time ago difference
SQL
1 vote162 views1 answer
Sql try catch
SQL
0 vote184 views1 answer
Fetching data from mysqldb
SQL
0 vote194 views1 answer
Sql column contains special character
SQL
11 votes187 views3 answers
How to get last row of table in sql
SQL