union and column data types

Former Member — Wed, 01 Jun 2011 15:32:48 GMT

When using UNION I receive "Cannot convert '' to a timestamp" when I try to run something like this:

select [field1], [field2] from [table]

union

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.

Re: union and column data types

johnsmirnios — Wed, 01 Jun 2011 15:36:14 GMT

Try NULL instead of ''.

Re: union and column data types

Former Member — Wed, 01 Jun 2011 16:17:32 GMT

Great. That did the trick. Much appreciated.

Question Re: union and column data types in Technology Q&A

union and column data types

Re: union and column data types

Re: union and column data types