Change default date of mysql

Question

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

Answer 1

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