I know that – result is rounded to next integer number
From: [email protected] [mailto:[email protected]] Sent: Wednesday, January 06, 2016 10:36 AM To: [email protected] Subject: Re: [firebird-support] Extract seconds from timestamp select cast(extract(second from cast('12.12.2016 23:59:59:4900' as timestamp)) as integer) from rdb$database 59 On Wednesday, January 6, 2016 10:37 AM, "'Bogdan' [email protected] [firebird-support]" <[email protected]> wrote: Hi all I wonder if this is an error or sql srandard: select cast(extract(second from cast('12.12.2016 23:59:59:9000' as timestamp)) as integer) from rdb$database gives 60 Regards < div class="yiv3464183871MsoNormal" id="yui_3_16_0_1_1452055013363_4929"> Bogdan --- Ta e-pošta je bila pregledana z Avast protivirusnim programom. https://www.avast.com/antivirus
