Subject Re: [firebird-support] Add 1 minute to a TimeSta mp
Author Mark Rotteveel
Post date 2015-03-10T20:26:36Z
Yes, add specified in the SQL standard.

Mark


----- Reply message -----
Van: "'Softtech Support' stwizard@... [firebird-support]" <firebird-support@yahoogroups.com>
Aan: <firebird-support@yahoogroups.com>
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 instead of (1.0/24.0) I used (1.0000/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 days:
tsTest = (:tsTranCreateDate - (2.0));
Correctly returns 10/29/2012 7:50:16 AM
 
One hour:
tsTest = (:tsTranCreateDate - (1.00000/24.0));
Correctly returns 10/31/2012 6:50:16 AM
 
One minute:
tsTest = (:tsTranCreateDate - (1.00000/1440.0));
Correctly returns 10/31/2012 7:49:16 AM
 
One second:
tsTest = (:tsTranCreateDate - (1.00000/86400.0));
Incorrectly returns 10/31/2012 7:50:15 AM
 
Mike
 
----- Original Message -----
Sent: Tuesday, March 10, 2015 3:02 PM
Subject: Re: [firebird-support] Add 1 minute to a TimeStamp

 

In the code provided below I meant to type 2012 not 201
 
----- Original Message -----
Sent: Tuesday, March 10, 2015 3:01 PM
Subject: Re: [firebird-support] Add 1 minute to a TimeStamp

 

Firebird v1.5.3
 
Does anyone know what's going on here?
 
DECLARE VARIABLE tsTranCreateDate TimeStamp;
DECLARE VARIABLE tsTest TimeStamp;
 
Starting Value:
tsTranCreateDate = 10/31/201 7:50:16 AM
 
Two days:
tsTest = (:tsTranCreateDate - (2.0));
Correctly returns 10/29/201 7:50:16 AM
 
One hour:
tsTest = (:tsTranCreateDate - (1.0/24.0));
Incorrectly returns 10/31/201 6:52:40 AM
 
One minute:
tsTest = (:tsTranCreateDate - (1.0/1440.0));
Incorrectly returns 10/31/201 7:50:16 AM
 
One second:
tsTest = (:tsTranCreateDate - (1.0/86400.0));
Incorrectly returns 10/31/201 7:50:16 AM
 
Subtract 2 days works fine.  Subtract 1 hour is wrong.  Subtract one minute or 1 second does nothing
 
Any ideas?
 
Mike
 
 
----- Original Message -----
Sent: Tuesday, March 10, 2015 2:22 PM
Subject: [firebird-support] Add 1 minute to a TimeStamp

 

Greetings All,
 
What is the best way in a stored procedure to add a minute or a few seconds to a TimeStamp?
 
Thanks,
 
Mike


This email has been checked for viruses by Avast antivirus software.
www.avast.com




This email has been checked for viruses by Avast antivirus software.
www.avast.com




This email has been checked for viruses by Avast antivirus software.
www.avast.com




This email has been checked for viruses by Avast antivirus software.
www.avast.com