Current in Informix = Sysdate in Oracle ???
This is a discussion on Current in Informix = Sysdate in Oracle ??? within the Informix forums, part of the Database Server Software category; --> Hello, could everyone help me please. For Informix I'm looking for a SQL-Condition how I'm using it in Oracle. ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 08:31 AM
| ||||
| ||||
 Current in Informix = Sysdate in Oracle ??? Hello, could everyone help me please. For Informix I'm looking for a SQL-Condition how I'm using it in Oracle. When I want to calculate a timespan from now to14 days, - in Oracle I use sysdate-14. - how can I use the same in Informix. Current-14 wont work. Many Thanks for Supporting me. Philipp Landolt      |
|
04-20-2008, 08:31 AM
| ||||
| ||||
| Re: Current in Informix = Sysdate in Oracle ??? "Philipp Landolt" <philipp.landolt@swisscom.com> wrote: > > could everyone help me please. > For Informix I'm looking for a SQL-Condition how I'm using it in Oracle. > > When I want to calculate a timespan from now to14 days, > - in Oracle I use sysdate-14. > - how can I use the same in Informix. Current-14 wont work. CURRENT will return a DATETIME value, TODAY will return a DATE, so depending on the value you want returned, you have a couple of options. If you want a DATETIME value, use: CURRENT - 14 UNITS DAY If you want a DATE value, use: TODAY - 14 I hope this helps. -- June Hunt |
 |
« Enterprise Replication
|
RE: Washington Area Informix User Group meeting - Tuesday, June 7, 2005 »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 10:32 PM.
