Turns out that firebird uses the precision of the used decimal, so instead of
(1.0/24.0) I used (1./24.0)
Here is a version that works correctly:
DECLARE VARIABLE tsTranCreateDate TimeStamp;
DECLARE VARIABLE tsTest TimeStamp;
Starting Value:
tsTranCreateDate = 10/31/2012 7:50:16 AM
Two
In the code provided below I meant to type 2012 not 201
- Original Message -
From: 'Softtech Support' stwiz...@att.net [firebird-support]
To: firebird-support@yahoogroups.com
Sent: Tuesday, March 10, 2015 3:01 PM
Subject: Re: [firebird-support] Add 1 minute to a TimeStamp
Hi
Our product used to run on FB 2.0 with the character set configured to
'NONE'. We released a new version using FB 2.5 and character set to
UTF8. One of our sites had been storing Chinese data in their database
using the Chinese langauge pack and Windows XP. After converting the
database