/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

0 vote174 views1 answer
Postgresql heritage
SQL
0 vote163 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
0 vote174 views1 answer
Search mysql database for column
SQL
10 votes187 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote177 views1 answer
New rails app with mysql
SQL
0 vote220 views1 answer
Parent and child link in mysql
SQL
1 vote202 views1 answer
Epoch time converter in snowflake
SQL
0 vote174 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote192 views1 answer
Renommer base sql
SQL
0 vote195 views1 answer
Including parameters in OPENQUERY
SQL