Ive been looking around the internet and these forums for tutorials of how to change the time offset but none of them have worked so far. I am trying to add a time offset which is grabbing both the date and the offset number from the table.
This is how the date looks in mysql "2006-07-26 08:36:01"
I have been trying to make the offset of "-8" hours which it grabs from the table too but everytime i try it changes the date or year so i end up messing up.
If its possible how would i make it so the date looks like "2006-07-26 8:36 PM" and not the military time.
thanks