| Subject | RE: [firebird-support] Extract seconds from timestamp |
|---|---|
| Author | Bogdan |
| Post date | 2016-01-06T10:12:47Z |
I know that – result is rounded to next integer number
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Wednesday, January 06, 2016 10:36 AM
To: firebird-support@yahoogroups.com
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
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
< div class="yiv3464183871MsoNormal" id="yui_3_16_0_1_1452055013363_4929">
Bogdan
|
Ta e-pošta je bila pregledana z Avast protivirusnim programom.
|