Now() vs GetDate()

Question

I am migrating my database from sqlserver to mysql when i come to getDate() function in sqlserver the replacement in mysql is Now() but Now() not returned the exact result and format that getDate() returned.

Is there any solution to tweak the Now() result to make as same as getDate()

getDate() result : 2014-01-07 00:28:46.017

Now() result     : 2014-01-07 10:28:03

Answer 1

I overcome the problem of microsecond by usage of

    sysdate(3) returned '2014-01-07 10:52:07.252'

Thanks for every one suggestions.