I have this query that I'm using in coldfusion:
Insert into ps_manager_employee_ids (manager_emplid,emp_id,last_name,first_name,hire_d t,rehire_dt,emp_status,union_status)
values ('#manageremplid#','#emplid#','#last_name#','#firs t_name#','#hire_dt#','#rehire_dt#','#emp_status#', '#union_status#')
I'm trying to insert some date values, but they are entering as 1/1/1900 instead of NULL. How can I insert them as null instead?
|