Hi,
I have the following information in a mysqldb.
Date and time format is :+DATE: %m-%b-%y TIME: %H:%M:%S
Data is accumulated every 5 minutes.

DATE TIME ROUTER INTERFACE MIN AVG MAX
01-Jan-04 13:02:25 als 1 23 34 45
01-Jan-04 13:02:25 als 2 12 14 45
01-Jan-04 13:07:25 als 1 63 68 85
01-Jan-04 13:07:25 als 2 12 14 45

Are my date and time formats suitable?
I know how to generate a date to date query using 'BETWEEN'
But how do i do a query for 01-Jan-04 11:00:00 to 01-Jan-04 12:25:00 for say ,router 1.
Is between applicable here?
would it be better if i take date and time together in epoch seconds?

Regards,
chimni