APEX

APEX version = 2.0
DB Version = 10g rel2
Issue:
APEX will not insert a date with a format of 'DD-MON-YYYY HH24:MI:SS' into a date field via autoprocessing in a form/report implementation and the item is a text field or hidden item. The timestamp portion is always incorrect (shows midnight instead of the true time).

The report will display the format shown above so long as I choose that format mask. The item is set for 'database column' on the date column I am working with and that format mask is chosen for that item. I also tried creating a computation that explicitly sets a variable to a value with that mask and that doesn't work -- always hacks off the timestamp. I have set the instance's nls_date_format to that mask and confirmed that setting is current. I then, via sqlplus (with no nls settings in place at the session level) , updated the same column with sysdate and confirmed the full (and correct) date/time is seen. I then do the same from apex and the result is the timestamp portion of that date format is always set to midnight. SQL Workshop/SQL Commands and issue a "select sysdate from dual" and it returns a date of "20-SEP-06". This tells me that the apex environment, somewhere/somehow, is setting the nls_date_format to DD-MON-RR but where? And how do I change that?

Can anyone shed light on this or can someone confirm that this is just an issue in Apex 2.0 (I see posts where timestamp is a problem in 2.0 -- perhaps the timestamp portion of a date format as well?)

Thanks in advance

null