Thanks for your help. I was able to get this to work, using a combination of things.
$sql = "SELECT CONVERT_TZ(s.time,'+00:00','-05:00') as formatted_date.......
$time = date("D M j h:i:s A",strtotime($row['formatted_date']));
Search found 3 matches
- Fri Feb 10, 2006 9:56 am
- Forum: PHP - Code
- Topic: [SOLVED] Date Function with time format 2006-02-10T23:00:00Z
- Replies: 6
- Views: 635
- Fri Feb 10, 2006 9:35 am
- Forum: PHP - Code
- Topic: [SOLVED] Date Function with time format 2006-02-10T23:00:00Z
- Replies: 6
- Views: 635
I could pull the parts out as you describe, and then add / subtract the number of hours to get it into my time zone. However, I feel as though PHP should have a function that deals with this type of timestamp. Since XMLTV is providing it, I can't imagine that I would have to go through so much troub...
- Fri Feb 10, 2006 9:18 am
- Forum: PHP - Code
- Topic: [SOLVED] Date Function with time format 2006-02-10T23:00:00Z
- Replies: 6
- Views: 635
[SOLVED] Date Function with time format 2006-02-10T23:00:00Z
I am trying to convert this time stamp into my time zone (EST), and display it like MM/DD/YY HH:MM PM.
I can't figure out what date function deals with the time zone.
Current time string (from XMLTV):
2006-02-10T23:00:00Z
I can't figure out what date function deals with the time zone.
Current time string (from XMLTV):
2006-02-10T23:00:00Z