Store Date Time with Oracle Apex

oracle datetime oracle11g oracle-apex
Bishan picture Bishan · Jun 15, 2012 · Viewed 11k times · Source

There is a hidden field as last_updated_date in my Oracle Apex application form. I have set SYSDATE as default value of that field. After adding data, I'v checked database table and data in last_updated_date column is show as 15-JUN-12 00:00:00. Time is not saved.

How could I save both date and time?

Answer

Tony Andrews picture Tony Andrews · Jun 15, 2012

In the hidden item's properties set:

  • Source Format Mask to DD-MON-YYYY HH24:MI:SS
  • Default Value to TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')
  • Default Value Type to PL/SQL Expression

Related questions

How to insert date values into table

How can I insert into table with different input using / ,with date datatype? insert into run(id,name,dob)values(&id,'&name',[what should I write here?]); I'm using oracle 10g.

Read More
Is java.sql.Timestamp timezone specific?

I have to store UTC dateTime in DB. I have converted the dateTime given in specific timezone to UTC. for that I followed the below code. My input dateTime is "20121225 10:00:00 Z" timezone is "Asia/Calcutta" My Server/DB(oracle) is …

Read More
In Oracle SQL: How do you insert the current date + time into a table?

I've written below code, but it only seems to insert the current date and not the current time. Anyone knows how to do that? insert into errortable (dateupdated,table1id) values (TO_DATE(sysdate, 'dd/mm/yyyy hh24:mi:ss'),1083);

Read More