select dummy date from a query
Hi All, i have a query , SELECT col1, ??? from table1 union SELECT col1,col2 from table 2 . where col1 of table1 is string and col1 of table2 is a string , col2 of table 2 is date. I need to select a nulldate from table1. i dont have any date datatype in table 1. i tried date(nulldate),date(null) but getting exception.