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
Yes, add specified in the SQL standard.
Mark
- Reply message -
Van: "'Softtech Support' stwiz...@att.net [firebird-support]"
Aan:
Onderwerp: [firebird-support] Add 1 minute to a TimeStamp
Datum: di, mrt. 10, 2015 21:17
Turns out that firebird uses the precision of the used decimal, so
Decimal literals are numeric, not floating point. 1.0 / 24.0 is numeric(18,2)
so the value is 0.04 and not 0.041666...
You need a double value, so use 1E0/24.
To answer your original question: in more recent versions of Firebird you can
use DATEADD.
Mark
- Reply message -
Van: "'Softte
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 day
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