insert null into datetime field

dmorand

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?

Oct 31 '08 #1

code green

Insert an empty value

Oct 31 '08 #2

ck9663

try this:


Happy Coding!

-- CK

Oct 31 '08 #3