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' [email protected]
[firebird-support]" <[email protected]> wrote:
<!--#yiv3464183871 #yiv3464183871
.yiv3464183871ygrp-photo-title{clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}#yiv3464183871
div.yiv3464183871ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px
solid black;height:62px;width:62px;}#yiv3464183871
div.yiv3464183871photo-title a, #yiv3464183871 div.yiv3464183871photo-title
a:active, #yiv3464183871 div.yiv3464183871photo-title a:hover, #yiv3464183871
div.yiv3464183871photo-title a:visited {text-decoration:none;}#yiv3464183871
div.yiv3464183871attach-table div.yiv3464183871attach-row
{clear:both;}#yiv3464183871 div.yiv3464183871attach-table
div.yiv3464183871attach-row div {float:left;}#yiv3464183871 p
{clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv3464183871
div.yiv3464183871ygrp-file {width:30px;}#yiv3464183871
div.yiv3464183871attach-table div.yiv3464183871attach-row div div a
{text-decoration:none;}#yiv3464183871 div.yiv3464183871attach-table
div.yiv3464183871attach-row div div span {font-weight:normal;}#yiv3464183871
div.yiv3464183871ygrp-file-title {font-weight:bold;}#yiv3464183871 -->
<!--#yiv3464183871 _filtered #yiv3464183871 {font-family:"Cambria
Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv3464183871
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv3464183871
#yiv3464183871 p.yiv3464183871MsoNormal, #yiv3464183871
li.yiv3464183871MsoNormal, #yiv3464183871 div.yiv3464183871MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri",
"sans-serif";}#yiv3464183871 a:link, #yiv3464183871
span.yiv3464183871MsoHyperlink
{color:blue;text-decoration:underline;}#yiv3464183871 a:visited, #yiv3464183871
span.yiv3464183871MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv3464183871
span.yiv3464183871EmailStyle17 {font-family:"Calibri",
"sans-serif";color:windowtext;}#yiv3464183871 .yiv3464183871MsoChpDefault {}
_filtered #yiv3464183871 {margin:70.85pt 70.85pt 70.85pt
70.85pt;}#yiv3464183871 div.yiv3464183871WordSection1 {}-->
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
