[RESOLVED] Mixing DATE_FORMAT() and DATE_ADD()?

[Channel5]

I'd like to change the timezone on my times and then format the time afterward.

Is it possible to add two commands into one?

Essentially, this is the idea of what I'm trying to accomplish:

DATE_FORMAT(time, '%I:%i %p') AND DATE_ADD(time, INTERVAL 2 HOUR) AS time

[Lars_Berg]

DATE_FORMAT(time + interval '2' hour,'%I:%i %p')

[Channel5]

Awesome, thanks!