更改mysql的默认日期

From last three days I used to the set the posted date of event e.t.c but automatically my server provide me one date back.

I also use default setting like :

date_default_timezone_set('Asia/Kolkata');

and use mysql code like :

$sql="insert  into event set event_name = '".trim(ucfirst($data['event_name']))."' ,
event_description = '".trim(ucfirst($data['event_description']))."' ,
event_posted_date = now() ;
mysql_query($sql);

But it save one date back.

Thanks and Regards

Try to use date from PHP insted of NOW()

 $today =date("Y-m-d H:is");
 $sql="insert  into event set event_name = '".trim(ucfirst($data['event_name']))."' ,
 event_description = '".trim(ucfirst($data['event_description']))."' ,
 event_posted_date = '$today' ";

OR

Find the file in your mysql server mysql.conf,check out the default-time-zone.,Change to Asia/Kolkata

execute this mysql query before executing your query

$sql_set_time =  "SET time_zone = 'Asia/Kolkata' ";

are you on localhost or any other web server ?

even if you set date_default_timezone_set('Asia/Kolkata');

this function will show the date and time that set to Asia/Kolkata in your server.

may be date in your server set wrong(if on localhost, system time may be wrong).