/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

2 votes164 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote205 views1 answer
Mysql readable output
SQL
8 votes143 views2 answers
Mysql get first x characters
SQL
5 votes158 views1 answer
Oracle list packages
SQL
0 vote149 views1 answer
Mysql get longest string in column
SQL
0 vote184 views1 answer
Wordpress make wp user in db
SQL
0 vote142 views1 answer
Postgresql where clause not working
SQL
0 vote218 views3 answers
How to find all role in mysql
SQL
0 vote105 views1 answer
Check id exist or not in sql
SQL
28 votes209 views6 answers
Foreign key
SQL