SQL: Comparar dos fechas entre sí

SQL SERVER:

SELECT TOP (200) * FROM   mitabla
WHERE (fh_ped BETWEEN CONVERT(datetime, '2014-11-26 18:00:00', 101) AND CONVERT(datetime, '2014-11-27 18:00:00', 101))
MYSQL:

SELECT * FROM tickets
WHERE DATE(fecha_creacion) BETWEEN '2013-11-26 18:00:00' AND '2014-12-31 18:00:00' limit 0,200