var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
Try this -
where ih_date > (current - 2 units year)