Hi,

Think this is what you're after? If not, please give us more detail on what's not working, e.g. any errors you receive, or incorrect results.

Select create_time

From ticket_history

where create_time = @BeginningDate

Note in your first piece of code you're aliasing the table as Create_Date, not the field, not sure if that's what you're trying to do?

Thanks