Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010
    Posts
    4

    Unanswered: Creating a timeline

    Hello,

    Can anyone give me some advice on how to create a timeline in sql?

    I work in the nhs and I am trying to create a timeline of clinician's activities. Ideally it will show each minute between the two dates as a row and then count whether the clinican was working that minute (based on the consultation start and end dates).

    So it would be between the @fromdate and the @todate, eg/ 18:00 to 18:02

    and would result something like:

    Time | With Patient
    18:00 | 1
    18:01 | 1
    18:02 | 0

    Is this possible? Any help would be greatly appreciated.

    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    does this need to be solely in MySQL, or can you do some of the processing in another (frotn end tool/app language)

    you may be able to generate the non patient time by JOINing to another table whihc has 0..59 in it and JOIN using the minute of the form/todates
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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