Time Increment [message #287280] |
Tue, 11 December 2007 16:33  |
lowcash75
Messages: 67 Registered: February 2006
|
Member |
|
|
In a table I have start_time and end_time for a particular event. I need to break that out into 1/2hr increments till the end_time.
Example --
Event_id Start_Time End_Time
1 5/1/2007 10:00:00 AM 5/2/2007 8:00:00 AM
I need a sql that can translate this into several rows based on 1/2 hr increment.
1 5/1/2007 10:00:00 AM
1 5/1/2007 10:30:00 AM
1 5/1/2007 11:00:00 AM
...
...
...
1 5/2/2007 7:30:00 AM
Any suggestions on how to do this.
Thanks!
|
|
|
|
|