Query / Union of tables with date column
Hi,
I want to create a new query table based on Table1 and Table2:
Table1
Column1 (Text)
Column2 (Date)
X 30 Apr, 2009 23:15:34
Y 12 May, 2009 23:15:47
Table 2
Column1 (Text)
Column2 (Date)
Z 18 May, 2009 23:15:34
Using this SQL Select Query:
SELECT "Column1", "Column2" FROM "Table1"
UNION ALL
SELECT "Column1", "Column2" FROM "Table1"
Executing the Query the result is OK:
Column1 (Text)
Column2 (Date)
X 30 Apr, 2009 23:15:34
Y 12 May, 2009 23:15:47
But, after saving the same query and pressing <view mode> I get other result:
Column1 (Text)
Column2 (Date)
X 01 Jan, 1970 00:00:02
Y 01 Jan, 1970 00:00:02
Any idea to solve that?