oracle - compare date

[charlotte]

hi, help needed!

i'm doing a vb.net project!
i use MS Access as my database at the beginning.
so i use:-

CDate(valid_date) < # " & DateTime.Now.ToString("dd/MM/yyyy") & "#

to get some record that the valid_date is < than today date!
it work well when using MS Access.
(NOTE: data type for valid_date is in VARCHAR not in Date)

but when my move my database to Oracle.
it has a problem!
i cannot use the CDate function. an error as below occur!


One or more errors occurred during processing of command. ORA-00911: invalid character

[font=Arial, Helvetica, Geneva, SunSans-Regular, sans-serif]Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: One or more errors occurred during processing of command. ORA-00911: invalid character[/font]




so any help can be provided regarding compare the date when database is store in Oracle!


regards;
charlotte

 

[bob.walker]

Oracle doesn't use pound signs(#) for dates.

CDate(valid_date) < " & DateTime.Now.ToString("dd/MM/yyyy") & "