I am trying to write a simple SQL statement which will take a string
(startdate) in the format DDMMYYYY and compare it to a date stored in
an Oracle database. My SQL is as follows:

<%

"select * from tblhistory where datechanged = '" & startdate & "'"

%>

The field datechanged in the Oracle database is set up using the
Sysdate variable, on a previous occasion.

Any ideas how I can get my startdate variable into the correct format
so that I can compare it with the 'datechanged' field?

Thanks in advance.

(..a little late, but anyway) First of all, check what the datechanged field returns. i think that includes the hour except the date. So, i think you have to "clear" your database field before you can compare it with or get the startDate like Date & " " Time which returns something like 22/7/2003 9:48:16 pm

Cheers
Kostas Lagos