Informix - how to decrease 30 minutes from current time
liat.barsela wanted to subtract 30 minutes from a datetime parameter, as Sybase dateadd does. Richard Harnden suggested datetime(2008-04-14 10:00) year to minute - 30 units minute. Another poster suggested casting: SELECT '2008-04-14 10:00'::DATETIME YEAR TO MINUTE - 30 UNITS MINUTE, with FROM systables WHERE tabid=99. The original poster confirmed both worked.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
hello, I'm trying to decrease 30 minutes from datetime recieved vy paramter, but I need to correct syntax because none of the following working: select (2008-04-14 10:00) - 30 units minute or select "2008-04-14 10:00" - 30 units minute or select (2008-04-14 10:00) year to minute - 30 units minute I used to use dateadd function for sybase (select dateadd(mi,-30,'01/02/2008 10:30')) and I need help how to run it in informix.
On 22 Apr, 09:21, liat.bars...@gmail.com wrote: > hello, > > I'm trying to decrease 30 minutes from datetime recieved vy paramter, > but I need to correct syntax because none of the following working: > select (2008-04-14 10:00) - 30 units minute or > select "2008-04-14 10:00" - 30 units minute or > select (2008-04-14 10:00) year to minute - 30 units minute Almost, try: select datetime(2008-04-14 10:00) year to minute - 30 units minute > > I used to use dateadd function for sybase (select > dateadd(mi,-30,'01/02/2008 10:30')) > and I need help how to run it in informix.
On 22 Apr, 09:29, richard.harn...@googlemail.com wrote: > On 22 Apr, 09:21, liat.bars...@gmail.com wrote: > > > hello, > > > I'm trying to decrease 30 minutes from datetime recieved vy paramter, > > but I need to correct syntax because none of the following working: > > select (2008-04-14 10:00) - 30 units minute or > > select "2008-04-14 10:00" - 30 units minute or > > select (2008-04-14 10:00) year to minute - 30 units minute > > Almost, try: > > select datetime(2008-04-14 10:00) year to minute - 30 units minute > There's always the arcane "EXTEND" syntax but why bother when you can CAST the input value (also, give the resultant expression a name such as "time_diff"'): SELECT "2008-04-14 10:00"::DATETIME YEAR TO MINUTE - 30 UNITS MINUTE time_diff ... and remember to add a FROM clause (because you have to SELECT from somewhere, even if it's a dummy): FROM systables WHERE tabid=99 will always work (tabid 99 is the engine version entry)
On Apr 22, 11:49 am, i...@perrior.net wrote: > On 22 Apr, 09:29, richard.harn...@googlemail.com wrote:> On 22 Apr, 09:21, liat.bars...@gmail.com wrote: > > > > hello, > > > > I'm trying to decrease 30 minutes from datetime recieved vy paramter, > > > but I need to correct syntax because none of the following working: > > > select (2008-04-14 10:00) - 30 units minute or > > > select "2008-04-14 10:00" - 30 units minute or > > > select (2008-04-14 10:00) year to minute - 30 units minute > > > Almost, try: > > > select datetime(2008-04-14 10:00) year to minute - 30 units minute > > There's always the arcane "EXTEND" syntax but why bother when you can > CAST the input value (also, give the resultant expression a name such > as "time_diff"'): > > SELECT "2008-04-14 10:00"::DATETIME YEAR TO MINUTE - 30 UNITS MINUTE > time_diff > > ... and remember to add a FROM clause (because you have to SELECT from > somewhere, even if it's a dummy): > FROM systables WHERE tabid=99 > will always work (tabid 99 is the engine version entry) THANKS A LOT both are working !!!!!