This discussion is archived
1 Reply Latest reply: Oct 3, 2012 11:31 PM by Denes Kubicek RSS

Default System date and time in Tabular form

Vedant Explorer
Currently Being Moderated
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

  • 1. Re: Default System date and time in Tabular form
    Denes Kubicek Oracle ACE Director
    Currently Being Moderated
    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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points