SQL to fetch data between 2 dates

1. SELECT * from table1 where Larq between (to_date (' 2008-9-3 ',' Yyyy-mm-dd ')) and (To_date (' 2008-9-5 ',' yyyy-mm-dd '))
   2.SELECT * from table1 where larq>=to_date (' 2008-9-3 ',' yyyy-mm-dd ') and Larq <=to_ Date (' 2008-9-5 ',' yyyy-mm-dd ')
   

Select COUNT (1) from T_vehicle T where t.createts between To_date (' 2015-7-7 17:13:00 ', ' yyyy/mm/dd hh24:mi:ss ') and to_date (' 2015-7-7 20:55:00 ', ' yyyy/mm/dd hh24:mi:ss ')

To_date (' 2015-7-7 17:13:00 ', ' yyyy/mm/dd hh24:mi:ss ')

To_char (sysdate, 'yyyy/mm/dd hh24:mi:ss')

To_date is an Oracle text-to-date function that must be used
Similarly, date-to-text uses the TO_CHAR function
To_number function for text to value

SQL to fetch data between 2 dates