Hi guys
How can i display a date which straddles at midnight, as two seperate dates
here is my data
Is this is possible using sql. Thanks for any help
How can i display a date which straddles at midnight, as two seperate dates
here is my data
Code:
id start end Duration
1 18/07/2005 18:00:00 19/07/2005 04:30:00 10.30
2 18/07/2005 09:00:00 18/07/2005 17:30:00 8.30
should be displayed as
id start end Duration
1 18/07/2005 18:00:00 18/07/2005 00:00:00 6.0
1 19/07/2005 00:00:00 19/07/2005 04:30:00 4.30
2 18/07/2005 09:00:00 18/07/2005 17:30:00 8.30