NOW time off by 2 hours

Not sure if this is a bug, or if it’s because the NOW is getting the date/time from the server (shared host). If it’s getting it from the server, is there a way to get the users local date/time in a server connect?

What I need to do is set a field create_date to the date/time when the user created the record, in their local time. I’m using NOW and it’s currently recording it as two hours later than my local time.

Thanks.