what is the difference between now() and current_date()?
NOW() returns a constant time that indicates the time at which the statement began to execute. ... Current_date returns the time stamp of the client while sysdate returns the time stamp of the server. If both server and the client are on the same machine, then, the result of both commands are the same.