AW: [firebird-support] Re: Round the Time

['Check_Mail' check_m...@satron.de [firebird-support]]

Thank you


-Ursprüngliche Nachricht-
Von: 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_m...@satron.de [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:'
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

[firebird-support] Re: Round the Time

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

'Check_Mail' check_m...@satron.de [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:' 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

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/