Re: Current in Informix = Sysdate in Oracle ???

Posted in 2005

Obnoxio The Clown — Mon, 6 Jun 2005 18:43:05 +0100 (BST) — source: Usenet: comp.databases.informix

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