Oracle date

Question

User261516802 posted

In Oracle Today_date datatype date. I tried all code but i can not insert data from Asp .net page.

Insert into Client(Today_date) values(DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss"))

Is giving error that "Month is invalid"

I used all code like....
DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss")
DateTime.Now.ToString(new CultureInfo("en-GB"));
to_date() function with format as "MM/dd/yyyy HH:MI:SS AM

Now i want to know is there work around oracle that we can set Datatype date correct so we can insert from asp.net page date?

I can not insert date from asp.net C# to oracle.

Answer 1

User-20777992 posted

User this!!!

DateTime.Now.ToString("dd/MMMM/yyyy hh:mm:ss")

As Oracle takes full month name in the date format.

Answer 2

User261516802 posted

It is still giving error "ORA-01843: not a valid month "

Answer 3

User-20777992 posted

Oops!!!

Sorry I forgot to replace '/' with '-'.

Pl. use the following one.

DateTime.Now.ToString("dd-MMMM-yyyy hh:mm:ss")

One more thing...do you need to store time also? If not then you can try juss the following one.

DateTime.Now.ToString("dd-MMMM-yyyy")

Answer 4

User269602965 posted

INSERT INTO Client (Today_date) VALUES (SYSDATE)

is an SQL statement,

so use the Oracle SYSDATE function

This creates an Oracle date-time equivalent to the .NET DateTime.Now function.