Results 1 to 2 of 2

Thread: Group By Hour (VB6)

  1. #1

    Thread Starter
    Lively Member Carmell's Avatar
    Join Date
    Dec 2015
    Posts
    105

    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.

    Name:  1.jpg
Views: 335
Size:  40.8 KB

    I want to know also your thoughts on the above image how to generate txtfile with that output from sql.

    Thanks.

  2. #2
    PowerPoster
    Join Date
    Jun 2013
    Posts
    7,219

    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
  •  



Click Here to Expand Forum to Full Width