In the current apex.oracle.com 22.1.3
I created a table:
CREATE TABLE xxx
( "ID" NUMBER(8,0),
"EMAIL" VARCHAR2(64),
"FRIEND_NAME" VARCHAR2(32),
"MY_NAME" VARCHAR2(32),
"CREATED_DATE" DATE DEFAULT sysdate
)
/
I created a form to submit "ID","EMAIL","FRIEND_NAME","MY_NAME" to add row,
the new row was created ok, except sysdate is 07-19-2022 00:00:00,
I did NOT use trunc(sysdate), what happens to the time portion of the sysdate?
P.S. I also tried to pass the created_date as a parameter with a value of sysdate,
still 07-19-2022 00:00:00
It is NOT due to the "format mask", it is just like in the table, when I queried in
"SQL COMMANDS"
Please advise. thanks!