Oninit cdi / Archive
Talk to an expert →

Informix - how to decrease 30 minutes from current time

Posted in 2008

Topics: General Discussion

liat.barsela@gmail.com — — source: Usenet: comp.databases.informix

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.

↪ replying to liat.barsela@gmail.com
richard.harnden@googlemail.com — — source: Usenet: comp.databases.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.

↪ replying to richard.harnden@googlemail.com
iiug@perrior.net — — source: Usenet: comp.databases.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)

↪ replying to iiug@perrior.net
liat.barsela@gmail.com — — source: Usenet: comp.databases.informix

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 !!!!!