/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

62 votes508 views8 answers
Mysql add column
SQL
0 vote240 views1 answer
Replace \n sql
SQL
0 vote211 views1 answer
Sql get guid
SQL
8 votes215 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote227 views1 answer
Executescalar in sql server
SQL
3 votes200 views1 answer
Only join in sql
SQL
0 vote202 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
1 vote233 views3 answers
How to update column name in psql
SQL
0 vote241 views1 answer
Sp help text in postgresql
SQL
0 vote207 views1 answer
Replace content value from old to new sql
SQL