Subject Extract seconds from timestamp
Author Bogdan

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




Avast logo

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