thanks :)

I have query now like this
select
CAST( ( extract(day from lopp)||'.'||extract(month from
lopp)||'.'||extract(year from lopp) ||' 17:30:00' ) as date) as lopp
from toopaev

this is perfect :)

Only problem, if time is 00:00:00 the time part is left empty. why?
For example I get result "15.09.2004"

but when time is anything else from 00:00:00 it works fine. for example
"15.09.2004 8:30:00"

What is different when using 00:00? is there some way to use 24:00?