Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: query for info between time on date an time1 on date1

    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
    Last edited by rajdeep; 01-21-04 at 03:46.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •