'Check_Mail' check_mail@... [firebird-support] a écrit :

> Dateadd is an option or extrac t the complete time in hours and minutes, but
> can I do this more simple?

for fun

cast(overlay( cast(cast('now' as timestamp) as char(24)) placing
'00:0000' from 18 for 7) as timestamp )

--
Norbert Saint Georges
http://tetrasys.fi