APEX date picker with SYSDATE default Oracle Tips by Burleson Consulting

You can create an APEX screen item with the "date picker" icon to allow the end-user to choose the date value from a calendar.  We start by choosing the "date picker" type from the "create item" wizard":

Next we choose the date date display format for the APEX screen item:

Next, we specify the default value of SYSDATE for the date item using the to_char function (in this example to_char(sysdate,'dd-mm-yyyy')).  Note that we must also choose the "PL/SQL Expression" for the default value type:

Now, when we execute our HTML-SB screen we see the date widget and the default date value:

Clicking the calendar icon display a calendar of the current month and wllows the end-user to choose another data for the screen:

When updating the database from a calendar chosen value (date picker, we need to convert the value upon insert:

insert into
   airline_names
(
   airline_name,
   effective_date
)
values
(
   upper(:p666_airline_name),
   to_date(:p666_effective_date,'dd-mm-yyyy')
);

SEE CODE DEPOT FOR FULL SCRIPTS

---

APEX support:

For APEX development support just call to gat an Oracle Certified professional for all APEX development projects.

APEX book and code samples:

Easy Oracle HTML-DB Application Express Create Dynamic HTML with Oracle Includes online APEX code depot Buy it now for 30% off - Only $27.95