27.2 DATE_POPUP Function
Use this function with forms that include date fields. The DATE_POPUP
function dynamically generates a date field that has a popup calendar button.
Syntax
APEX_ITEM.DATE_POPUP(
p_idx IN NUMBER,
p_row IN NUMBER,
p_value IN VARCHAR2 DEFAULT NULL,
p_date_format IN DATE DEFAULT 'DD-MON-YYYY',
p_size IN NUMBER DEFAULT 20,
p_maxlength IN NUMBER DEFAULT 2000,
p_attributes IN VARCHAR2 DEFAULT NULL,
p_item_id IN VARCHAR2 DEFAULT NULL,
p_item_label IN VARCHAR2 DEFAULT NULL)
RETURN VARCHAR2;
Parameters
Table 27-2 DATE_POPUP Parameters
Parameter | Description |
---|---|
|
Number that determines which |
|
This parameter is deprecated. Anything specified for this value is ignored |
|
Value of a field item |
|
Valid database date format |
|
Controls HTML tag attributes (such as disabled) |
|
Determines the maximum number of enterable characters. Becomes the maxlength attribute of the |
|
Extra HTML parameters you want to add |
|
HTML attribute ID for the |
|
Invisible label created for the item |
Example
The following example demonstrates how to use APEX_ITEM.DATE_POPUP
to create popup calendar buttons for the hiredate
column.
SELECT
empno,
APEX_ITEM.HIDDEN(1,empno)||
APEX_ITEM.TEXT(2,ename) ename,
APEX_ITEM.TEXT(3,job) job,
mgr,
APEX_ITEM.DATE_POPUP(4,rownum,hiredate,'dd-mon-yyyy') hd,
APEX_ITEM.TEXT(5,sal) sal,
APEX_ITEM.TEXT(6,comm) comm,
deptno
FROM emp
ORDER BY 1
See Also:
Oracle Database SQL
Language Reference for information about the TO_CHAR
or TO_DATE
functions
Parent topic: APEX_ITEM (Legacy)