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
  • [firebird-support]... 'Bogdan' bog...@mordicom.si [firebird-support]
    • Re: [firebird... Virna Constantin costel...@yahoo.com [firebird-support]
      • RE: [fire... 'Bogdan' bog...@mordicom.si [firebird-support]
    • Re: [firebird... Lester Caine les...@lsces.co.uk [firebird-support]
      • RE: [fire... 'Bogdan' bog...@mordicom.si [firebird-support]

Reply via email to