I am trying to pass datetime to a varchar field which is in oracle. I want to show all the records after 8am today.Plz mark as Answer if your problem is resolved. Reddy

You need to use the : character not the @character to pass params to oracle. Example :- SELECT BLAH FROM OracleTable WHERE SomeDate = TO_DATE(:mydateparameter,'dd-MON-yyyy') I think you can use for example "12/FEB/1999" in that format without a TO_DATE conversion. Check the oracle documentation for more information on the actual date format to pass.

Hi Nick2012, This is a question of Oracle, it might be better if you could get some services from Oracle at this link http://www.oracle.com/technetwork/index.html Thanks, Challen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.