Conversion to local date and time

PHP
1

hello all, in my scripts,i want to be able to record the current local date and local time in a database,
i know using CURDATE() and CURTIME() records the current date and time for the server location,
what i want are functions that do the same things for a particular fixed time zone, say GMT+1, for example.

Many thanks.

2

This php function might help in setting the time zone for the dates. http://php.net/manual/en/function.date-default-timezone-set.php

3

The server’s time zone is something you know, so all you need to do is make the adjustment from that time zone to the one you want to store.

Use CONVERT_TZ to do that.

For the time to convert, give it CURRENT_TIMESTAMP or CURTIME().

4

How will you discern the current time then? Is that something you are going to get from the client?