A quick follow up on this question.

The solution you provided works fine for daily session data, but want if a customer wants to know the times of day...

Thanks for your help Remi.

New results using DATEADD(HH, DATEDIFF(HH, 0, TIME_STAMP), 0):

SessionTime      Hour

 40                  4/19/2004 8:00:00 AM

 20                  4/19/2004 9:00:00 AM

 0.57                4/19/2004 10:00:00 AM

I can manipulate the Hour results in the code section of the...

Thanks for the quick response Remi, but something is still not working right.

These are the results I got with my query.

SessionTime        TIME_STAMP

 20                    4/19/2004 8:21:00 AM

 20                    4/19/2004 8:42:00 AM

 20                    4/19/2004 9:02:00 AM

 0.57                ...