Not sure which group to post in.... I have a problem with dates

Posted in 2005

sh0t2bts — Wed, 02 Feb 2005 20:16:02 GMT — source: Usenet: comp.databases.informix

Hi All, I am trying to pull data into an SQL 2000 Server from an Informix server I can do "select * from My_table where row_date = '12262004'" This works fine.. But I am trying to schedule this as a local package and have the date use the system date I have tried changing the date to "Date()-1' and "Current_Timestamp-1" but both fail. I get a syntax error. Can someone advise me on how I should be setting the date up?? Many Thanks Mark