Last Update Date
518643Jun 22 2006 — edited Jun 25 2006Hi -
I am creating a simple form on top of a table - I let APEX create the form. Each table has a creation_date, last_update_date, created_by and last_updated_by column. What I am trying to do is have those 4 columns be hidden in the form, and set the 2 dates fields = sysdate. The problem is that its showing up just as DD-MON-YYYY format. When it gets inserted into the table, and I do a to_char(creation_date, 'DD-MON-YYYY HH24:MI:SS'), its truncated to 22-JUN-2006 00:00:00.
How do I insert the full timestamp? In forms I can just call fnd_standard.set_who and it takes care of it for me. I even tried setting the default value to to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'), which worked when I displayed the field as text, but it didnt know to convert it to a date before inserting.
By the way, I really don't want to stick a trigger on every single table just to set the dates, so if there is an application way to do it, I would prefer going that route personally. Thanks!