---
title: "SELECT mellan 2 datum"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/93958-select-mellan-2-datum"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "matthew"
published: "2004-01-04T19:09:30.000Z"
updated: "2004-01-04T19:37:34.000Z"
replies: 2
views: 254
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/93958-select-mellan-2-datum"
---

# SELECT mellan 2 datum

## #1 — matthew, 2004-01-04T19:09Z

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...

Permalänk: https://www.webforum.nu/p/93958

## #2 — LarsG, 2004-01-04T19:13Z

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')
```

Permalänk: https://www.webforum.nu/p/1243765

## #3 — matthew, 2004-01-04T19:37Z

Tackar ödmjukast!

Permalänk: https://www.webforum.nu/p/1243773

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/93958-select-mellan-2-datum