Tnx
Regards Bogdan From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Wednesday, January 06, 2016 6:53 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Extract seconds from timestamp On 06/01/16 08:37, 'Bogdan' bog...@mordicom.si [firebird-support] wrote: > 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 http://www.firebirdsql.org/refdocs/langrefupd21-intfunc-extract.html Check the notes;) -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk --- Ta e-pošta je bila pregledana z Avast protivirusnim programom. https://www.avast.com/antivirus