Craig

SELECT * FROM tbl WHERE yourcol >= '20071010 23:00' AND yourcol
<='20071011 07:00'




[quoted text, click to view]

Assumming your columns are datetime format,a

Try

SELECT * FROM tbl WHERE yourDatecol + YourTimeCol >= '20071010
23:00' AND yourcol
<='20071011 07:00'


Paddy

Hi Paddy.

My columns are datetime format but I get this error when I try to
select, "You may not add a date type and a time type".

Cheers

[quoted text, click to view]

[quoted text, click to view]

Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, data types, etc. in
your schema are. If you know how, follow ISO-11179 data element naming
conventions and formatting rules. Sample data is also a good idea,
along with clear specifications. It is very hard to debug code when
you do not let us see it.

This is a common design flaw you need to correct. The root cause of
this attribute splitting is confusing the concept of a field and a
column. Make them into real DATETIME columns which model complete
facts instead of parts of a fact.

Do it in the DDL instead of kludging it in the DML. Unless you do
that, you will never have any data integrity and your DML will run
like glue with the extra overhead of correcting the design flaw on the
fly.

Has someone created bespoke data types on your system?

Standard sql only has datetime or smalldatetime data types.

Paddy