Subject RE: [firebird-support] Extract seconds from timestamp
Author Bogdan

I know that – result is rounded to next integer number


From: []
Sent: Wednesday, January 06, 2016 10:36 AM
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





On Wednesday, January 6, 2016 10:37 AM, "'Bogdan' bogdan@... [firebird-support]" <> 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



< div class="yiv3464183871MsoNormal" id="yui_3_16_0_1_1452055013363_4929">  



Avast logo

Ta e-pošta je bila pregledana z Avast protivirusnim programom.