When using UNION I receive "Cannot convert '' to a timestamp" when I try to run something like this:
select [field1], [field2] from [table]
select [field1], '' from [second table];
Field1 is the same in both tables. In the first select statement field2 data type is timestamp but I don't want field2 pulled from the second select statement. Is there a way to cast or format field2 in the second statement to run in this instance?
Appreciate any assistance.
asked 01 Jun '11, 15:32
Try NULL instead of ''.
answered 01 Jun '11, 15:36