W
WroteForLuck
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.
(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.