Thank you
-----Ursprüngliche Nachricht----- Von: [email protected] <[email protected]> Gesendet: Donnerstag, 5. Dezember 2019 18:34 An: [email protected] Betreff: [firebird-support] Re: Round the Time 'Check_Mail' [email protected] [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
