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' bogdan@... [firebird-support]" <firebird-support@yahoogroups.com> 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

 

Bogdan