Copy NULL into a Date field

[benjamenus]

I am copying data from table 1 to table 2 (these exist in different databases). Table 2 has several extra fields where the data type is Date. This is the SQL

Copy from ...
Append t2
Using select t1.*
NULL as AdditionalDateField;

This produces a data type error, presumably because NULL is not in the appropriate format for AdditionalDateField. I've tried the following but still get an error.

NULL as to_date(AdditionalDateField)

Does anyone have any ideas please?

 

[benjamenus]

Sorry to waste your time, I found this answer for anyone interested:

to_date(NULL) as AdditionalDateField;

Easy when you know how!