/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

25 votes227 views4 answers
Metadata
SQL
0 vote242 views1 answer
Mysql query to check record exists in database table or not
SQL
22 votes263 views3 answers
Year format in date mysql
SQL
2 votes243 views2 answers
Postgres select duplicate columns
SQL
-1 vote235 views1 answer
Su: Authentication failure mysql
SQL
0 vote246 views1 answer
PSQL use LIKE with timestamps
SQL
4 votes236 views1 answer
Postgresql create table with index
SQL
11 votes243 views1 answer
Mysql text type max length
SQL
3 votes226 views1 answer
Index using in query plsql
SQL
3 votes268 views5 answers
No module named 'MySQLdb'
SQL