1 Reply Latest reply: Oct 4, 2012 1:31 AM by Denes Kubicek RSS

    Default System date and time in Tabular form

    Vedant
      Dear All,

      i have crated tabular form and i have one column ENTERD_TIME in tabular form.I want to enter Default system date and time in that column in tabular form.

      how can i display default date and time in ENTERD_TIME Column in tabular form.
      Format Need
      
      DD-MON-YYYY HH:MIPM
      Thanks
        • 1. Re: Default System date and time in Tabular form
          Denes Kubicek
          Under Tabular Form Attributes > Default Type enter PL/SQL Expression and the Default to SYSDATE. Under "Column Attributes" set the format to DD-MON-YYYY HH:MIPM.

          Denes Kubicek
          -------------------------------------------------------------------
          http://deneskubicek.blogspot.com/
          http://www.apress.com/9781430235125
          http://apex.oracle.com/pls/apex/f?p=31517:1
          http://www.amazon.de/Oracle-APEX-XE-Praxis/dp/3826655494
          -------------------------------------------------------------------