Informix and DATE function.

I stored a date as string in sqlserver datable. Later i change my database to INFORMIX using same data. Now the same string is stored informix.  Now i need to retrive records for a perticural period of time till current date.

i dont know much about sql syntax in informix....and functions...can anyone send me a query for this.....

A similiar sql syntax is here:-
-----------------------------

Select * ABC where name = "vinay" and  Convert(datetime,tdate) between dateadd("mm","3",getdate()) and getdate() order by tdate";



vinayknAsked:
Who is Participating?
 
earthman1968Commented:
Not sure of what your trying to do on SQLSERVER. But you need to use the DATE() function in Informix. You may also need to use the INTERVAL functions if you are wanting data for a date range.

Check out the manuals on the informix web-site (www.informix.com)
0
 
vinayknAuthor Commented:
Can anyone give someattention to it?
0
 
vinayknAuthor Commented:
Nobody answered it...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.