Thanks.




-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Gary Benade
Sent: 02 June 2006 10:26 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Decrement Date by 1 hour

>Dion wrote
>How do I decrement the system date by an hour ie current_timestamp - 1
>hour.

I use the standard firebird UDF's, those relevant to your question are:
ADDMILLISECOND
ADDSECOND
ADDHOUR
ADDDAY
ADDMONTH
ADDWEEK
ADDYEAR
So you would use ADDHOUR( current_timestamp, -1) to go back one hour

FWIW
Gary





++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links







--
Internal Virus Database is out-of-date.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.7.0/346 - Release Date: 23/05/2006


--
Internal Virus Database is out-of-date.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.7.0/346 - Release Date: 23/05/2006