Here i have a date entry as by default mysql
Input: '2017-03-9 06:27:28'
Output: '2017-03-9 11:27:28'
i want to convert this time using php in GMT +5 format please help me the function to solve this
Asked
Active
Viewed 48 times
1
Sahil Gulati
- 15,028
- 4
- 24
- 42
Mudassar Zahid
- 305
- 2
- 14
-
Your date string looks broken. Can you at least show us what output you want? – Tim Biegeleisen Mar 28 '17 at 06:01
-
please check this @TimBiegeleisen – Mudassar Zahid Mar 28 '17 at 06:04
-
Assuming you're storing your dates in GMT in the database, and also assuming you have a date type, would you find it acceptable to just add 5 hours in query itself? – Tim Biegeleisen Mar 28 '17 at 06:05
-
yes you are right but data is to be used in different countries so by default i have saved GMT 0 , i want to fetch and convert it with different regions on php level – Mudassar Zahid Mar 28 '17 at 06:08
-
please @TimBiegeleisen try in php i am waiting for your answer – Mudassar Zahid Mar 28 '17 at 06:10
-
Have you seen this: http://stackoverflow.com/questions/11386308/add-x-amount-of-hours-to-date – Tim Biegeleisen Mar 28 '17 at 06:11
-
thanks @TimBiegeleisen this is help full using `date("Y-m-d H:i:s", strtotime('2017-03-9 06:27:28 +10 hours'))` your suggestion was helpful – Mudassar Zahid Mar 28 '17 at 06:20
-
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/139209/discussion-between-mudassar-zahid-and-tim-biegeleisen). – Mudassar Zahid Mar 28 '17 at 06:25
1 Answers
2
$string=strtotime("2017-03-9 06:27:28"); //converting time to timestamp
$timestamp=strtotime("+5 hours",$string);//added zone time
echo date("Y-m-d H:i:s", $timestamp); //displaying new time
Sahil Gulati
- 15,028
- 4
- 24
- 42
-
-
can you please review my yesterday question http://stackoverflow.com/questions/43047820/how-to-calculate-time-difference-with-schedule-working-b-w-two-time-stamps – Mudassar Zahid Mar 28 '17 at 06:35
-
@MudassarZahid do you want to get time difference between `start_time` and `end_time` – Sahil Gulati Mar 28 '17 at 06:37
-
yes but want to skip other hours then working hours, and weekend days – Mudassar Zahid Mar 28 '17 at 06:38