SELECT mellan 2 datum

Jag vill välja ut alla poster mellan 2 st datum.

SELECT pk_vehicle_reg_nr, violation_datetime
FROM Violation, Vehicle
WHERE	(pk_vehicle_reg_nr = fk_vehicle_reg_nr) AND
	(violation_datetime BETWEEN '2001-01-01 21:04:52.540000' AND '2003-12-27 21:04:52.540000');

Felmeddelande: Operands are not comparable

Datatypen är TIMESTAMP och dbms Mimer...

Då får du använda standard SQL.

SELECT pk_vehicle_reg_nr, violation_datetime
FROM Violation, Vehicle
WHERE	(pk_vehicle_reg_nr = fk_vehicle_reg_nr) 
AND (violation_datetime 
BETWEEN timestamp '2001-01-01 21:04:52.540000' 
AND timestamp '2003-12-27 21:04:52.540000')

Tackar ödmjukast!