Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2011

    Unanswered: SQL to Informix conversion

    Hello, I have the following functional SQL statement that I need converted over to Informix syntax.. thanks for the help!

    select ar_invoice_nbr from ar_item where ar_invoice_nbr in (select ih_nbr from si_invoice where ih_date > dateadd(year, -2,getdate()))

    All this is doing is selecting invoice line items from invoices over the past 2 years.

  2. #2
    Join Date
    Apr 2011
    Try this -

    where ih_date > (current - 2 units year)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts