How to add TIME part do DATE in SELECT query? i am using FB 1.0.3.
dialect 1.


I have tried:
select
CAST(extract(day from MyField)||'.'||extract(month from
MyField)||'.'||extract(year from MyField) ||' 00:00:00'|| as date) as
MyField
from MyTable

00:00:00 is the time I wan't to add.
but this gives me "General SQL error token unknown As".


using just
select

CAST(extract(day from lopp)||'.'||extract(month from
lopp)||'.'||extract(year from lopp) ||' 00:00:00' as date) as lopp
from toopaev

gives me only date, but does not have time part.



How to do it better?