I have a table that holds time stamps like this:
1108 - 9:46:08
1108 - 9:49:47
1104 - 10:13:54
1105 - 11:41:53
1105 - 11:55:11
etc
How do I just get the hours part of that field? Something like the following.
1108 9:46:08 - 9
1108 9:49:47 - 9
1104 10:13:54 - 10
1105 11:41:53 - 11
1105 11:55:11 - 11
1108 - 9:46:08
1108 - 9:49:47
1104 - 10:13:54
1105 - 11:41:53
1105 - 11:55:11
etc
How do I just get the hours part of that field? Something like the following.
1108 9:46:08 - 9
1108 9:49:47 - 9
1104 10:13:54 - 10
1105 11:41:53 - 11
1105 11:55:11 - 11