Matt
02 Apr 2002, 14:05
I have on my site homepage a section where it displays the next episode of "Dark Angel" that is going to air, along with the time and a link to the episodes info in the episode guide.
The problem is that its stored on a US server, and I want to make it so that the time is offset by 5 hours so that the next episode shows up as soon as the current one is over. So with Dark Angel finishing at 10PM over here, at 10PM I want it to switch to the next episode in the table, rather than switching at 2am when its 10PM in the US.
I managed to do this before somewhere but I deleted the damn file the other day and all I remember is I used DATE_ADD() to add on the offset amount of hours to the time so that it would change at the right time.
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
That is the SQL where start is the start date and time (DATETIME)
Can anyone tell me what I am doing wrong please :(
Matt
The problem is that its stored on a US server, and I want to make it so that the time is offset by 5 hours so that the next episode shows up as soon as the current one is over. So with Dark Angel finishing at 10PM over here, at 10PM I want it to switch to the next episode in the table, rather than switching at 2am when its 10PM in the US.
I managed to do this before somewhere but I deleted the damn file the other day and all I remember is I used DATE_ADD() to add on the offset amount of hours to the time so that it would change at the right time.
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
That is the SQL where start is the start date and time (DATETIME)
Can anyone tell me what I am doing wrong please :(
Matt