Help with query

[tyson.crouch]

Hey guys,

In my DB, i've got appointments set, and i need to select all appointments which are an hour or less away.

For example i want to do something to the following (Dont worry, i know this wont work as is)

SELECT * FROM timetable WHERE time has one hour remaining;

[smantscheff]

Have a look at the date/time functions: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html
To avoid conversion issues use something like

SELECT * FROM timetable WHERE unix_timestamp(time) - unix_timestamp() < 3600

Alternatively you could use the timediff() function.

[rpk2006]

Read this article: Changing Times in MySQL

You need to use the BETWEEN clause also.

Something like:

SELECT * FROM timetable WHERE AppointmentTime BETWEEN CurTime() AND CurTime() + ...

The query above is just to give u an idea. I don't remember the actual functions.