So I need to write a query that will if something was modified in the last 15 min. The problem is that the data is stored as UCT time and I am WST so UST +8
ie so if I had to make a change at say 2pm it would show up in the database as taking place at 6am when I did a straight select from that table...
So how do I select x, y, z, from T where z <= 15
z is in uct format and 15 is equal to current time - 15 min
Hope this helps...
Rock and Roll Detective