Passing Date Parameter into Oracle

[Jim318]

Hello,

I am trying to pass a date parameter in a select statement such as select * from Names where Last_update = To_Date('01/30/2004', MM/DD/YYYY)

When I try to use a variable for the parameter I cannot get the query to execute. For example: select * from Names where Last_update = To_Date(seldate, 'MM/DD/YYYY').

I simply keep getting a syntax error message when I run into my executereader statement.

I'd appreciate any help or advice.

Thanks,
Jim

 

[Dimandja]

Have you tried To_Date(' & seldate & ', 'MM/DD/YYYY')?

 

[chiph]

Have you tried using ADO.NET parameter objects with the Oracle provider, and passing a DateTime object that contains your date value?

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first

 

[Jim318]

Still no luck.

I am pulling the date value from the DateTimePicker.

Thanks,
Jim

 

[PankajBanga]

try this...

Format(seldate, "MM/dd/yyyy")

Use the case as shown. check datatype for seldate, it should not be String if using Format.

http://home.iprimus.com.au/pankajbanga