467,134 Members | 917 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,134 developers. It's quick & easy.

Selecting multiple start and end time out of datetime column

hi guys, i am currently creating a sql select statement for my project. The project would create a log data every minute if the user is away from the work station, thus the log would pretty much look like

Name DateTime
Alvin 11/09/08 11:30:00AM
Alvin 11/09/08 11:31:00AM
Alvin 11/09/08 11:32:00AM
Alvin 11/09/08 03:24:00AM
Alvin 11/09/08 03:25:00AM

I would need a select statement which could produce

Name StartTime EndTime Interval
Alvin 11:30:00AM 11:32:00AM 2
Alvin 03:24:00AM 03:25:00AM 1

could anyone help me with it?
=)
Nov 17 '08 #1
  • viewed: 1408
Share:
1 Reply
debasisdas
Expert 4TB
kindly post the query that you are working on.
Nov 17 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Agoston Bejo | last post: by
2 posts views Thread by Lauren Quantrell | last post: by
5 posts views Thread by uthuras@hotmail.com | last post: by
3 posts views Thread by klawiter@nd.edu | last post: by
1 post views Thread by Bob Loveshade | last post: by
6 posts views Thread by fniles | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.