On 27 Sep, 08:54, secSwami <parvind...@gmail.com> wrote:
| I have few mysql4 statements that I would like
| to convert to mysql 5 format.
This statement fails in version 4 as well. Have you thought of reading
the relevant section of the manual and following the instructions? I
don't think the format of this statement has changed between the
versions.

| after doing some research I found that this now()
| function has been replaced.
It has? What research did you do? No one told me that it had been
replaced and it appears that no one told the developers either since I
am still using it in version 5 and so are lots of other people.