[firebird-support] Round the Time

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

Hello,

 

is there a simply function available to round the time to entire minutes?
18:15:45 can be 18:15:00 to calculate full minutes between begin and end.

 

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

 

Thank you.

 

Regards

 

Olaf

 

 

ODP: [firebird-support] Round the Time

[Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]]

Now possibility:
Exctract + cast
Substring + cast

But you can vote on something more usefull:
http://tracker.firebirdsql.org/browse/CORE-5623

regards,
Karol Bieniaszewski