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

Posted in 2005

June C. Hunt — Wed, 2 Feb 2005 15:42:15 -0500 — source: Usenet: comp.databases.informix

"sh0t2bts" <sh0t2bts@hotmail.com> wrote: > 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?? Have you tried: select * from My_table where row_date = TODAY -- June Hunt

↪ replying to June C. Hunt

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

No I will give that a go tomorrow when i can get back on the server Thanks Mark "June C. Hunt" <june_c_hunt@hotmail.com> wrote in message news:36cs9dF4se9otU1@individual.net... > "sh0t2bts" <sh0t2bts@hotmail.com> wrote: >> 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?? > > Have you tried: > select * from My_table where row_date = TODAY> > -- > June Hunt > >