I have a problem now

[Arunkumar Koloth]

Hi I have a problem now in my sql query iam using

NOW()

To Insert My Current Date and time when i do this i can't get my country date and time. how can i change this to my local time? i Used

date();

Function Also But The Date is shown here wrong!. i thing the date is showing here is my server date and server time! Anyone please tel me how can i fix this problem? Please Help Me To Do this :(( :(( :(( Arunkumar.T

Arunkumar.T

[Peter_in_2780]

Use date-default-timezone-set()[^] early in your PHP. That will set PHP time correctly. I don't know how you would set the SQL server time - maybe it has a similar function. Peter

Software rusts. Simon Stephenson, ca 1994.

[cjoki]

http://www.electrictoolbox.com/mysql-set-timezone-per-connection/[^]

Chris J www.redash.org

[Peter_in_2780]

Thanks. I was pretty sure that it should exist, but didn't know the details (and, to be honest, didn't have the energy to google it). I'm familiar with the PHP one because I work with Apache servers running on 3 different timezones that should all appear to be local. Cheers, Peter

Software rusts. Simon Stephenson, ca 1994.

[yiday]

You can use php timestamp

[arya1685]

Hi, You can set the default time zone by using

date_default_timezone_set()

or by

string date ( string $format [, int $timestamp = time() ] )

for more details please see http://php.net/manual/en/function.date.php[^]

Thanks & Regards

Arya1685

“You are not only responsible for what you say, but also for what you do not say”