RE: Not sure which group to post in.... I have a problem with dat

"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.. It looks as though the date is not a date format: If it is a character string, try creating a variable in the DTS package and populating it in the format you require; then use a place holder in the select statement and assign the variable to it. Good luck Cliff. > > 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 ---------------------------------------------------- This message is for the named person's use only. Privileged/confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message, and notify us immediately. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorised to state them to be the views of any such entity. ---------------------------------------------------- sending to informix-list