Thank you


-----Ursprüngliche Nachricht-----
Von: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com>
Gesendet: Donnerstag, 5. Dezember 2019 18:34
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] Re: Round the Time

'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



------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu
there.

Also search the knowledgebases at
http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links