DateTime Value not the same with current time

Question

0.00/5 (No votes)

See more:

Hi!

I have a problem in my PHP or MySQL. It seems to be not returning the current Date and Time.

When I would run date() like 2015-28-01 1:47:00 [This is the time now], it would save in the database 2015-01-28 06:47:30??

Can someone help me to solve this?

Thank you so much and God bless. :)

Posted 27-Jan-15 18:56pm

Michelle Anne Rigor

Add a Solution

Comments

Praveen Kumar Upadhyay 28-Jan-15 1:42am

You can use date() with format. Search in google date format in php, you will get many links explaining this.

Michelle Anne Rigor 28-Jan-15 1:46am

I have already tired that one. But still returns the wrong date. I have set the Timezone. Thankfully it worked when I added the timezone. But is there a way where I will not hard-code the timezone?

Sinisa Hajnal 28-Jan-15 2:28am

Did you check server time? Set a breakpoint and find out is it correct in your code BEFORE saving - that is, at which point do you get wrong time. Then work backwards to find the source of the problem.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Accepted Answer · 2015-01-27T20:34:00

Solution 1

If you want to set it permanently, open the php.ini, and add or modify this directive:

date.timezone=Asia/Singapore

restart Apache, then it will be fine.
I am using Singapore timezone as an example.

Posted 27-Jan-15 20:34pm

Peter Leow

Comments

Michelle Anne Rigor 28-Jan-15 3:01am

Thank you for this! Finally solve the problem. :D

Peter Leow 28-Jan-15 4:17am

You are welcome.