views:

10

answers:

0

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!!