Hello Zoran
Witch Component do you useing in Delphi FireDAC?
Are you shure, that that your clients uses the right client-library
fbclient.dll or GDS32.dll? Means FB 3.0.5 should use fbclient from V3.0.5
What FB Version do you use?
Best Regards
Gregor
Sent from Yahoo Mail. Get the app
On Thursday, April 30, 2020, 05:30:22 PM GMT+2, 'Zoran'
[email protected] [firebird-support] <[email protected]>
wrote:
Thank you, Karol.
Probably not FB message. I guess it’s coming from Delphi. It happens right
after I execute ‘qry.Open;’ statement.
What I was hopping for is if someone with Delphi background can shed some light
on Delphi handling this situation.
From: [email protected] <[email protected]>
Sent: Thursday, April 30, 2020 11:09 AM
To: [email protected]
Subject: ODP: [firebird-support] Timestamp in different regions
I do not suppose that this is Firebird message.
This looks like client program message.
regards,
Karol Bieniaszewski
Firebird 3.0.5, Delphi 10.3.3
In a table I have TIMESTAMP column. If I read that table from the client in the
same Region as server all is ok. If I read the same table where client is in
the different region than server, I get error message 'Could not parse SQL
TimeStamp string'.
In another words if server is in US and client is in US all is ok. If server is
in Europe and client is in Europe, all is ok. But, if server is in US and
client is in Europe (and vice-versa) I get this error.
Does anyone experience this, or am I missing something here?_,
Thank you
Zoran
#yiv7077494043 #yiv7077494043 -- #yiv7077494043ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7077494043
#yiv7077494043ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7077494043
#yiv7077494043ygrp-mkp #yiv7077494043hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7077494043 #yiv7077494043ygrp-mkp #yiv7077494043ads
{margin-bottom:10px;}#yiv7077494043 #yiv7077494043ygrp-mkp .yiv7077494043ad
{padding:0 0;}#yiv7077494043 #yiv7077494043ygrp-mkp .yiv7077494043ad p
{margin:0;}#yiv7077494043 #yiv7077494043ygrp-mkp .yiv7077494043ad a
{color:#0000ff;text-decoration:none;}#yiv7077494043 #yiv7077494043ygrp-sponsor
#yiv7077494043ygrp-lc {font-family:Arial;}#yiv7077494043
#yiv7077494043ygrp-sponsor #yiv7077494043ygrp-lc #yiv7077494043hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7077494043
#yiv7077494043ygrp-sponsor #yiv7077494043ygrp-lc .yiv7077494043ad
{margin-bottom:10px;padding:0 0;}#yiv7077494043 #yiv7077494043actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7077494043
#yiv7077494043activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7077494043
#yiv7077494043activity span {font-weight:700;}#yiv7077494043
#yiv7077494043activity span:first-child
{text-transform:uppercase;}#yiv7077494043 #yiv7077494043activity span a
{color:#5085b6;text-decoration:none;}#yiv7077494043 #yiv7077494043activity span
span {color:#ff7900;}#yiv7077494043 #yiv7077494043activity span
.yiv7077494043underline {text-decoration:underline;}#yiv7077494043
.yiv7077494043attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7077494043 .yiv7077494043attach div a
{text-decoration:none;}#yiv7077494043 .yiv7077494043attach img
{border:none;padding-right:5px;}#yiv7077494043 .yiv7077494043attach label
{display:block;margin-bottom:5px;}#yiv7077494043 .yiv7077494043attach label a
{text-decoration:none;}#yiv7077494043 blockquote {margin:0 0 0
4px;}#yiv7077494043 .yiv7077494043bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7077494043
.yiv7077494043bold a {text-decoration:none;}#yiv7077494043 dd.yiv7077494043last
p a {font-family:Verdana;font-weight:700;}#yiv7077494043 dd.yiv7077494043last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7077494043
dd.yiv7077494043last p span.yiv7077494043yshortcuts
{margin-right:0;}#yiv7077494043 div.yiv7077494043attach-table div div a
{text-decoration:none;}#yiv7077494043 div.yiv7077494043attach-table
{width:400px;}#yiv7077494043 div.yiv7077494043file-title a, #yiv7077494043
div.yiv7077494043file-title a:active, #yiv7077494043
div.yiv7077494043file-title a:hover, #yiv7077494043 div.yiv7077494043file-title
a:visited {text-decoration:none;}#yiv7077494043 div.yiv7077494043photo-title a,
#yiv7077494043 div.yiv7077494043photo-title a:active, #yiv7077494043
div.yiv7077494043photo-title a:hover, #yiv7077494043
div.yiv7077494043photo-title a:visited {text-decoration:none;}#yiv7077494043
div#yiv7077494043ygrp-mlmsg #yiv7077494043ygrp-msg p a
span.yiv7077494043yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7077494043
.yiv7077494043green {color:#628c2a;}#yiv7077494043 .yiv7077494043MsoNormal
{margin:0 0 0 0;}#yiv7077494043 o {font-size:0;}#yiv7077494043
#yiv7077494043photos div {float:left;width:72px;}#yiv7077494043
#yiv7077494043photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv7077494043
#yiv7077494043photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7077494043
#yiv7077494043reco-category {font-size:77%;}#yiv7077494043
#yiv7077494043reco-desc {font-size:77%;}#yiv7077494043 .yiv7077494043replbq
{margin:4px;}#yiv7077494043 #yiv7077494043ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7077494043 #yiv7077494043ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7077494043
#yiv7077494043ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7077494043
#yiv7077494043ygrp-mlmsg select, #yiv7077494043 input, #yiv7077494043 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7077494043
#yiv7077494043ygrp-mlmsg pre, #yiv7077494043 code {font:115%
monospace;}#yiv7077494043 #yiv7077494043ygrp-mlmsg *
{line-height:1.22em;}#yiv7077494043 #yiv7077494043ygrp-mlmsg #yiv7077494043logo
{padding-bottom:10px;}#yiv7077494043 #yiv7077494043ygrp-msg p a
{font-family:Verdana;}#yiv7077494043 #yiv7077494043ygrp-msg
p#yiv7077494043attach-count span {color:#1E66AE;font-weight:700;}#yiv7077494043
#yiv7077494043ygrp-reco #yiv7077494043reco-head
{color:#ff7900;font-weight:700;}#yiv7077494043 #yiv7077494043ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7077494043 #yiv7077494043ygrp-sponsor
#yiv7077494043ov li a {font-size:130%;text-decoration:none;}#yiv7077494043
#yiv7077494043ygrp-sponsor #yiv7077494043ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7077494043
#yiv7077494043ygrp-sponsor #yiv7077494043ov ul {margin:0;padding:0 0 0
8px;}#yiv7077494043 #yiv7077494043ygrp-text
{font-family:Georgia;}#yiv7077494043 #yiv7077494043ygrp-text p {margin:0 0 1em
0;}#yiv7077494043 #yiv7077494043ygrp-text tt {font-size:120%;}#yiv7077494043
#yiv7077494043ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7077494043
