Re: [Firebird-net-provider] Date Format

[<car...@te...>]

Hello:

>  Yes I'm using parameterized query. I also tried by using FbParameter. 
> In both the case I got the same behaviour.

This sampel works for me:

FbConnection connection = new FbConnection(connectionString);
connection.Open();

string sql = "insert into TESTS (ts) values (@date)";

FbCommand command = new FbCommand(sql, connection);

command.Parameters.Add("@date", FbDbType.Date).Value = 
DateTime.Now.ToString("MM/dd/yyyy");

int ra = command.ExecuteNonQuery();

connection.Close();




--
Best Regards

Carlos Guzmán Álvarez
vigo-Spain