php date() giving result 1 day ahead

Asked Aug 01 '18 at 16:35

Active Aug 01 '18 at 16:35

Viewed 256 times

I'm attempting to use PHP's date() function to search my database for today's date, but the result is always for tomorrows date.

This code:

$date = date("Y-m-d");

is currently giving me 2018-08-02, but it should be 2018-08-01

I've seen many questions on StackOverflow for this question:

The solution is the same on all of them; use date_default_timezone_set(), but I am already doing that in my index.php file.

date_default_timezone_set("US/Central");

I'm using a PHP framework, the index.php file is always loaded, no matter where I am in my application, and date_default_timezone_set() is the 2nd line ran for my whole application.

How can I make date() report the correct date?

asked Aug 01 '18 at 16:35

GrumpyCrouton

8,486
7
32
71

dump date_default_timezone_get(); before query, maybe your framework somewhere rewrite your call, also try to set it via phpini – bxN5 Aug 01 '18 at 16:38
1

What's the exact date? E.g. `var_dump(date('c'));` – Álvaro González Aug 01 '18 at 16:38
@ÁlvaroGonzález `string(10) "2018-08-02"` – GrumpyCrouton Aug 01 '18 at 16:40
1

Did you see the [list of PHP supported TZ](http://php.net/manual/en/timezones.america.php)? `US/Central` is not in... – Déjà vu Aug 01 '18 at 16:41
@RingØ I tried `America/Chicago` as well – GrumpyCrouton Aug 01 '18 at 16:41
set timezone to UTC like this date_default_timezone_set('UTC') and then try date fn. – SumitArya Aug 01 '18 at 16:41
Sometimes the problem is with the server's date itself. Make sure your server's date is correct. – HTMHell Aug 01 '18 at 16:41
2

What does `date` from the shell return? Maybe your server's clock is wrong. – Alex Howansky Aug 01 '18 at 16:42
@bxN5 I can't really dump it right before the query, because it's inside a class and I don't get any output. I did it on my view page however, and it said `US/Central`. I'll try phpini – GrumpyCrouton Aug 01 '18 at 16:42
@AlexHowansky It's looking like that may be the problem, I'm getting `Thu Aug 2 12:43:16 EDT 2018` – GrumpyCrouton Aug 01 '18 at 16:42
NTP is your friend ;-) – Déjà vu Aug 01 '18 at 16:45
Please run the statement I suggested or a similar one. I'd like to figure out the exact full date with hours, minutes, seconds and time zone. – Álvaro González Aug 01 '18 at 16:49
your server timezone is +2:30hrs – SumitArya Aug 01 '18 at 16:53
@ÁlvaroGonzález `string(25) "2018-08-02T11:53:34-05:00"` – GrumpyCrouton Aug 01 '18 at 16:53
1

@AlexHowansky Thank you, issue fixed by changing server timezone. Should this question be deleted? – GrumpyCrouton Aug 01 '18 at 16:56
No, don't delete, it's a valid question with a comment thread that might be helpful to others. – Alex Howansky Aug 01 '18 at 17:06
The time appears to be correct but the system clock is certainly one day ahead. Probably not a PHP issue at all. – Álvaro González Aug 01 '18 at 17:08
@ÁlvaroGonzález Yes, it was the time on the server itself that was wrong. – GrumpyCrouton Aug 01 '18 at 17:30

php date() giving result 1 day ahead

0 Answers0