Hi
i am using below query

select Year(current_date) from SYSIBM.SYSDUMMY1
UNION
select Month(current_date) from SYSIBM.SYSDUMMY1
UNION
select day(current_date) from SYSIBM.SYSDUMMY1


to select year month and day, this query works fine if the month and day are not same i.e.
if the date is 2011-09-08 than it returns
2011
9
8

but if the date is 2011-09-09 it only returns two rows
2011
9

in both the cases if i run queries individually it returns proper values..

Can you please tell me whats going wrong with this....
Thanks in advance

Use "UNION ALL" instead of "UNION".

UNION removes duplicated rows.

teachers will have big opportunities..
DB2 University