/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

6 votes113 views4 answers
Delete table sqlite
SQL
3 votes134 views1 answer
Set default today mysql
SQL
0 vote121 views1 answer
Enable Rabbitmq management plugin
SQL
4 votes125 views1 answer
Group by mysql and concatenate string
SQL
5 votes111 views1 answer
Oracle sysdate
SQL
4 votes118 views2 answers
Show all database inside postgresql
SQL
10 votes68 views1 answer
Oracle view dependencies
SQL
0 vote264 views1 answer
Get first match in each group mysql query
SQL
16 votes121 views1 answer
Mssql int max value
SQL
0 vote121 views1 answer
Like date sql server not working
SQL