how can we get today date with time instead of now() function.
Discussion posts and replies are publicly visible
If your requirement is to show "status age in days" as you mentioned in your original thread, (and i'm unsure why this required the creation of a new thread when it's essentially the same topic, but too late for that now), you should just be storing the original date(time) in question, then calculating the "age" at display time. This would be far, far easier than trying to figure out a way to get an "age" value coming from the DB in such a way that it updates by itself in real-time.