 |
|
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:
|
