/SQL/Oracle current timestamp insert statement

Oracle current timestamp insert statement

--if you want to hardcode the time stamp: 

insert
into tablename (timestamp_value)
values (TO_TIMESTAMP(:ts_val, 'YYYY-MM-DD HH24:MI:SS'));

--if you want the current time stamp to be inserted then:

insert
into tablename (timestamp_value)
values (CURRENT_TIMESTAMP);

Source: stackoverflow.com

Similar codes

23 votes290 views1 answer
How remove column in mysql
SQL
0 vote280 views1 answer
See Foreign Key
SQL
0 vote295 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
7 votes307 views3 answers
Postgresql dump and restore db
SQL
0 vote274 views1 answer
Mysql drop multiple tables at once
SQL
28 votes303 views4 answers
Delete database mysql
SQL
0 vote255 views1 answer
Create dabase postgresql
SQL
0 vote309 views1 answer
Primary key multiple
SQL
42 votes355 views6 answers
Install beautifulsoup
SQL
0 vote313 views1 answer
Oracle to_number
SQL