Storing null values in date/time field

[trisolve]

Hi,
I'm trying to update a field of type date/time to null value using sql query.

my sql query:
"Update jobs Set mydate.value = DBNull" ....

This doesn't work!
What do I need in this sql statement so that I can update date/time field with nothing (empty).
Thanks.

[hspc]

Hi
Please always send Database engine you use and the error message(s) you get.
anyway this should work if the field allows null values:
Update jobs Set mydate = Null

[trisolve]

Thanks a lot hspc!! :)