Here's my PHP code:
echo date('M j y g:i:A');
This doesn't display correct time. why?
-
Check the server's time zone.gen_Eric– gen_Eric2011-03-08 19:44:28 +00:00Commented Mar 8, 2011 at 19:44
-
i mean it displays correct date. but incorrect time.user628961– user6289612011-03-08 19:48:02 +00:00Commented Mar 8, 2011 at 19:48
-
@rocket: you again?haha. how to check server's time?user628961– user6289612011-03-08 19:48:42 +00:00Commented Mar 8, 2011 at 19:48
-
3What time does it display? Geez. What is the current time, and what time do you get?Pekka– Pekka2011-03-08 19:48:48 +00:00Commented Mar 8, 2011 at 19:48
-
@pekka: sorry, it displays march 8 2011, 7:49pm. but right now here in phil its 3:50am already.user628961– user6289612011-03-08 19:50:41 +00:00Commented Mar 8, 2011 at 19:50
|
Show 8 more comments
3 Answers
Insert this at the very top of your code:
date_default_timezone_set('Asia/Manila');
7 Comments
user628961
follow up question. how to insert date and time to a database with datetime datatype, so i can query it and display the inserted date and time.?
seriousdev
Just use
NOW(), like: INSERT INTO table VALUES ("random value", NOW())user628961
i used it, but i came back to same problem with incorrect time. ive inserted the default time zone. but it wont work on queried dates. help?
user628961
by the way heres how i echo my date from database- echo date('M j y g:i:A', strtotime($fetchcom['date']));
seriousdev
Right after you connected to the database, do this query:
SET time_zone = 'Asia/Manila' and then try to insert time again. |
fix the time zone in php.ini or in the code itself
Add something like this to your php.ini file date.timezone = "Asia/Manila", that will set the default without having you put in the date_default_timezone_set('Asia/Manila'); on every file that uses time functions
5 Comments
New Guy
Add something like this to your php.ini file
date.timezone = "Asia/Manila", that will set the default without having you put in the date_default_timezone_set('Asia/Manila'); on every file that uses time functions.
Naftali
@New Guy im adding that to the answer
user628961
where to locate php.ini file?
Naftali
usually if in UNIX/LAMP than in the etc folder
Naftali
so look for the php.ini in the PHP folder
It's most likely echoing the time on the server, which is often GMT. If you're time zone is GMT+5, you may need to add 5 hours to the timestamp.
For 5 hours...
$offset = 5 * 60 * 60;
echo date('M j y g:i:A', time() + $offset);
