Search found 3 matches

by aischallenge
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

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']));
by aischallenge
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...
by aischallenge
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