-
May 7th, 2018, 08:38 PM
#1
Thread Starter
Lively Member
Group By Hour (VB6)
How can I group by transactions like this
'0:01AM -1:00 AM' and it will interpret as 01
'1:01AM-2:00 AM' as 02
'10:01 PM-11:00 PM' as 23 and so on..
because I need to create a txtfile with this kind of format.
I want to know also your thoughts on the above image how to generate txtfile with that output from sql.
Thanks.
-
May 8th, 2018, 06:58 AM
#2
Re: Group By Hour (VB6)
...Group By DatePart('h', YourDateTimeField)
HTH
Olaf
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|