RE: Compare dates

2003-11-24 Thread Prakash Kamani
Hi Manisha I have used the same thing in a pretty different way. Basicallyi have stored the date in string format say 'MMDD' and then done simple comparison say 20031125<20031029 by converting it into Long format in my local code (note::this will specially work in case of MMDD forma

mySQL -- Any supporting function like RANK in ORACLE

2003-11-21 Thread Prakash Kamani
Hi I am using MySQL for certain queries and i need to find out RANK of the columns also. ORACLE provided a function RANK() by which it can be retrieved. Is there any similar function in MySQL by which same thing can be done. Thanks Prakash Kamani -- MySQL General Mailing List For list