• No problem.

    As you're querying MySQL, try this:

    Select create_time

    From ticket_history

    WHERE create_time >= @BeginningDate

    and create_time < DATE_ADD(@BeginningDate, INTERVAL 1 DAY)