SQL for between and time

In terms of writing time conditions, such as the time period from 2014/3/1 to 2014/3/31, a lot of people would write this

Select  from Table where between ' 2014/3/1 '  and ' 2014/3/31 '

In fact, the result of this query is from 2014/3/1 00:00:00 to 2014/3/31 00:00:00

So the question is, what would happen if there was a data time in ' 2014/3/31 11:12:12 '? Obviously, this data will be ignored. When querying about time, be sure to remember: minutes: seconds,

The correct statement for querying the March data should be

Select  from Table where between ' 2014/3/1 '  and '3/1::

SQL for between and time