Syntax for date range SQL query in OpenOffice Base

Question

I'm trying to SELECT based on a date in OpenOffice Base:

SELECT *
  FROM OrderTbl
  WHERE OrdDate BETWEEN #1/1/2007# AND #1/31/2007#

I've tried a number of variations, but nothing is working. What is the correct syntax?

have you tried single quotes instead of #s?

akf
– akf

2009-06-30 02:20:08 +00:00
Commented Jun 30, 2009 at 2:20 — akf
– akf, Commented Jun 30, 2009 at 2:20

David Walker · Accepted Answer · 2009-06-30 02:35:40Z

1

This should work:

SELECT * 
FROM OrderTbl
WHERE OrdDate BETWEEN '2007-01-01' AND '2007-01-31'

answered Jun 30, 2009 at 2:35

David Walker

1,5062 gold badges16 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

KuldipMCA · Accepted Answer · 2009-06-30 05:22:45Z

0

use below Query SELECT * FROM OrderTbl WHERE OrdDate BETWEEN cast(convert(varchar,'1/1/2007',101) as datetime) AND cast((varchar,'1/31/2007',101) as datetime)

answered Jun 30, 2009 at 5:22

KuldipMCA

3,1617 gold badges29 silver badges48 bronze badges

Collectives™ on Stack Overflow

Syntax for date range SQL query in OpenOffice Base

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related