Subject Re: Round the Time
Author Norbert Saint Georges
'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