Hi all, i'm stucked on a Date Column that stored a wrong Date.
i'm using VS 2010 with .NET 4 and oracle 11g (Oracle.dataAccess.dll version 2.112.0.1) and i have to fill a column with a full date (dd:mm:yyyy hh24:mi:ss)
I use a complex query with a lot of parameters in that way:
cmd.Parameters.add(":date", OracleDBType.Date, myDate, ParameterDirection.Input);
where cmd is OracleCommand and mtDate contains a DateType like ""
My query works well and as usual if i check the result with oracle sql developers I see a date format like DD-MON-YY
the issues occurrs when i try to read dates from the db with a query like
select to_char(MyDate, 'dd/mm/YYYY hh24.mi.ss') from MyTable;
the result of this query is something like "13/6/0010 00.00.00" with correct day and month but wrong year a all 0 as hour!
i tried a lot of things but I can't get rid of this!!
can anyone help me?
Thanks!!