I need to filter data based on the create_time field. Now the sql statement is as follows:

SELECT    * FROM    `sbhf_alarm` sa WHERE
unix_timestamp(sa.create_time) BETWEEN unix_timestamp('2016-05-25 14:07:56')
AND unix_timestamp('2017-05-25 14:07:56')

However, I found that this method has a bug, that is, when the upper limit time (arrow in the picture above) is too large, an error will be reported. As shown below:

The reason is that the unix_timestamp function converts time into seconds, and the time cannot be too large.

Question: Is there any other better way to filter time?
How is this problem generally solved? Please give me some advice, thank you very much...