Thank You. Let me check.
On Friday, 13 January 2017 1:13 PM, "liviuslivius
liviusliv...@poczta.onet.pl [firebird-support]"
wrote:
Hi, dbClick on IBTransaction component and you got Transaction editor -
and there you have all valuesgoogle for each value regards,Karol Bieniaszewski
On 12-1-2017 21:44, startx252...@yahoo.fr [firebird-support] wrote:
> What is the way to make a join from 2 tables in two respective database
> (in same server) ?
>
> ex :
>
> Db1
> TableA
>
>
> Db2
> TableB
>
>
> how can i make somethink like this :
>
> SELECT tA.MATRICRS, tB.name, tB.age
> FROM T
There are requests to implement Time zones in Firebird:
http://tracker.firebirdsql.org/browse/CORE-694
http://tracker.firebirdsql.org/browse/CORE-909
These two are in the "Optional features" list for Firebird 4:
https://www.firebirdsql.org/en/planning-board/
Best Regards
Stefan
--
Stefan H
On 12/01/2017 14:09, Tim Ward wrote:
> Sorry if this is a really basic question, but some time spent
> searching has failed to find for me the definitive detailed
> documentation on exactly how Firebird handles time zones (I'm
> particularly interested, to start with, in using CURRENT_TIMESTAMP
However what I'm actually seeing is as follows.
(1) Set a Linux machine to "Brazil/East". Check this using the "date"
command line command.
(2) Confirm that
select CURRENT_TIMESTAMP from rdb$database
does report the Brazilian local time as expected.
(3) Next, I've got a table with a TIMESTAMP
13.01.2017 13:09, Tim Ward t...@telensa.com [firebird-support] wrote:
> I just don't believe this. Can anyone make any other suggestion as to
> what is going on?
Is timezone on your Linux set globally or for each current user environment
independently?
--
WBR, SD.
-
On 13/01/2017 14:04, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 13.01.2017 13:09, Tim Ward t...@telensa.com [firebird-support] wrote:
>> I just don't believe this. Can anyone make any other suggestion as to
>> what is going on?
> Is timezone on your Linux set globally or
13.01.2017 16:46, Tim Ward t...@telensa.com [firebird-support] wrote:
> One thing I've now noticed is that running the trigger by updating a
> record via isql gives the correct, Brazilian, answer.
If you are running isql and connected to database in embedded mode, your
current
environment is