I just lunched a site and the date on my comment section happens to be different from what I had when using wamp server.What do I do? I have tried putting date_default_timezone to Africa/Lagos but no changes occur I have tried inserting this -setEnv TZ Africa/ Lagos in my .htaccess file all to no avail. so what next my fellow developer ?

Is your system time correct?

yaa it is ooo.

or could it be my php version is different from d one in my cpanel.

Did you add date_default_timezone before anything else on the page?
And how are you storing the data in the database? Are you using mysql's current timestamp as default or saving the time from php?

omoelu1:
Did you add date_default_timezone before anything else on the page?
And how are you storing the data in the database? Are you using mysql's current timestamp as default or saving the time from php?

I have added it as first line of code on d page.Yes I use timestamp in d date column on my table..I Neva had any prob wit date b4 buh dis one is giving me worries.The day month and year are correct but the time is always wrong and I can't do without it .e no go make sence

IkpemhiTG:


I have added it as first line of code on d page.Yes I use timestamp in d date column on my table..I Neva had any prob wit date b4 buh dis one is giving me worries.The day month and year are correct but the time is always wrong and I can't do without it .e no go make sence

If you haven't gotten it to work, try this:
Create a new date format using php's date method
$date = new date("Y-m-d H:I:a"
Then save this value as your current timestamp

omoelu1:

If you haven't gotten it to work, try this: Create a new date format using php's date method $date = new date("Y-m-d H:I:a" Then save this value as your current timestamp

ait...let's c how it goes...

Put this inside your php script -

[php]
date_default_timezone_set('Africa/Lagos'); //this is the code to preset your time-zone
[/php]

@Op have you been able to resolve this?

Just incase someone else gets in the same situation, here is a possible solution:

After using the php function date_default_timezone_set() to set the time_zone accordingly, if you still notice a discrepancy in your date when compared to the time_zone you've set, the culprit is most likely your data store.

If you have a CRUD application that writes to the Database using the database native function to insert datetime e.g Using php to insert a record into a MySQL database: "INSERT INTO table_name (created_at) VALUES (NOW())" (NOW() used in that insert statement is not a php function but a MySQL native function simply instructing your database to INSERT the value of its current datetime into that field. If the timezones are different, that value will differ too). Another case is when you've set a default value of 'CURRENT_TIMESTAMP' for that field, you must understand that the date that will be inserted is not affected by the timezone you've set using the date_default_timezone_set() function in your script. The inserted date will be determined based on the current time on the database server. So if my DBase server resides in a US timezone and I create records using the above methods, you'll notice these discrepancies.

Solutions:

1. Generate the date from your php script after setting the environment timezone using the date_default_timezone_set() function and then hand it to your query to insert. e.g

date_default_timezone_set('Africa/Lagos'); //set choice timezone
$current_datetime = date('Y-m-d h:i:s'); //generate current datetime for the set timezone

Your insert statement should now read: "INSERT INTO table_name (created_at) VALUES ('$current_datetime')";

The time current time for 'Africa/Lagos' timezone should now be inserted with the records on your database.

2. This second solution is not recommended, the above is a perfect but if your are not really interested in the exact datetime value. i.e you're not outputting them in the format '30 May 2016' or '30-05-2016' and only just want to display the difference between when the record was created and now. Maybe to display an 'Ago' kind of time format e.g 3 mins ago, 2 hours ago or 2 years ago. You can find the timezone that matches the current datetime of your database server and set your php environment timezone to this value, so that when you read the date from the database and run the function for the date calculation the time difference between record creation time and now still matches irrespective. This is an unrecommended hack but worth mentioning because it works.

Thank you.