Hi,
Under Oracle APEX 24.2.11, I have an item type date on a table item name is “P39_ENVOYE_LE”. I calculate his default value with this PL/SQL Expression :
TO_CHAR(CURRENT_DATE, 'DD/MM/YYYY HH24:MI')
Format mask of the item is: “DD/MM/YYY HH24:MI”. But I get an error when I submit the page :
It says that it is not a valid date. The example he gives is exactly matching my value format. Here is the debug:
Error: #LABEL# doit être une date valide, par exemple : 28/12/025 00:00.
- Additional info:
- Display location: INLINE_WITH_FIELD_AND_NOTIFICATION
- Association type: PAGE_ITEM
- Item name: P39_ENVOYE_LE
- Region id:
- Column alias:
- Row:
- Model instance id:
- Model record id:
- Internal error: false
- Common runtime error: false
- APEX error code:
- SQL code:
- SQL error:
- Backtrace: ----- PL/SQL Call Stack -----
object line object
handle number name
0x72fb9f5a8 1055 package body APEX_240200.WWV_FLOW_ERROR.INTERNAL_GET_ERROR
0x72fb9f5a8 1124 package body APEX_240200.WWV_FLOW_ERROR.INTERNAL_ADD_ERROR
0x72fb9f5a8 1179 package body APEX_240200.WWV_FLOW_ERROR.ADD_ERROR
0x79d5f8220 646 package body APEX_240200.WWV_FLOW_VALIDATION.PERFORM_BASIC_VALIDATIONS.VALIDATE_PAGE_ITEMS
0x79d5f8220 750 package body APEX_240200.WWV_FLOW_VALIDATION.PERFORM_BASIC_VALIDATIONS
0x79d5f8220 1085 package body APEX_240200.WWV_FLOW_VALIDATION.PERFORM
0x77bd9e5b0 4279 package body APEX_240200.WWV_FLOW.ACCEPT
0x776ad50c8 2 anonymous block
- Statement:
- Component: APEX_APPLICATION_PAGE_ITEMS P39_ENVOYE_LE (732579406485125919)
Furthermore , the time calculated with CURRENT_DATE is wrong. The hour calculated is one hour before the real hour. I am in France. So it display this “28/12/2025 15:56” but it is in reality “28/12/2025 16:56”. How to add one hour to this expression?
Best regards.