inserting date timestamp value to mysql thru php in godaddy hosting site

Question

Hi all, I'm using GoDaddy's Shared Linux hosting.

Using php i am inserting or updating the mysql database with create date or modified date using the variables
$datestring = "%Y:%m:%d %h:%i:%s";
$time = time();
$createdate= mdate($datestring, $time);

In this $createdate will be the variable i use to insert or update the table. But its updating the wrong value. ITs not the server time or localtime. mostly its 30 mins delay with godaddy's server time.

Pls help.

Answer 1

Edit: after some googling it looks like you're using CodeIgniter. You should have mentioned that in your question.

The format string you're using doesn't match MySQL's date format. You want to use:

$datestring = '%Y-%m-%d %H:%i:%s';

Answer 2

use in mysql query like DATE_FORMAT(purchaseDate, "%Y:%m:%d %h:%i:%s") function

Answer 3

Use date function of php

$createdate= date('Y-m-d H:i:s');