C# SQL Statement

[Pluto87]

Hi, I need a little help on this Sql Statement. The below function won't run in C#. I think and know my date function is wrong, can someone please correct the error? Thanks in advance!



string dataSQL = "";

dataSQL += " , Confirm_Date = to_date('" + DateTime.Now + "', 'MM/DD/YYYY HH:MI:SS AM') ";

 

[jbenson001]

What is the error you are getting, what is the definition of your SQL function? You need to provide more info.

 

[Pluto87]

I am getting an Execution fail. I believe it is this string because when I comment it out, it works fine.

 

[MarkSweetland]

What database are you attmpting to run against? to_date is Oracle specific syntax.


Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

[Pluto87]

I am attempting SQL. Yes I know the statement is in Oracle, but I seem to can;t figure the SQL syntax.

 

[Pluto87]

Nevermind, I figured it out!