I have a form where ther person is to enter a date and a time. The date is entering fine, but there is no time. How do I enter the time into the date column? Below is my code:
$sqlstmt="INSERT INTO sysadm.inqad_deployment (ENT_DTE, COMMENTS, LST_MNT_OPR_ID, LST_MAINT_TSMP )
values (to_date('$ent_dte $time', 'MM-DD-YYYY HH24:MI'), :comments, :session_userid, sysdate)";
$sqlstmt_arg = "comments" . DELIM . $comments . DELIM .
"session_userid" . DELIM . $session_userid;