Current in Informix = Sysdate in Oracle ???
Philipp Landolt
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
June C. Hunt
>
> 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
Obnoxio The Clown
Philipp Landolt said:
> 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.
Today - 14
?
--
Bye now,
Obnoxio
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche
A smile is a gift that is free to the giver and precious to the recipient.
But giving someone the finger is free too, and I find it more personal and
sincere.
sending to informix-list