help for inserting date in oracle

Question

0.00/5 (No votes)

See more:

sir, please help me that i am using oracle 10g, and trying to insert date in table by using 7/7/2012 or 2012/7/7 format type but month invalid error appear....please help me to rite format

Posted 10-Aug-12 21:55pm

parshdhage

Add a Solution

Comments

Kenneth Haugland 11-Aug-12 4:50am

Try american culture on the datetime. Write tostring("MM/dd/yyyy") and see if that solves it :)

parshdhage 13-Aug-12 4:20am

thaxxxx..!!! its working..!!

AmitGajjar 11-Aug-12 5:24am

what is your database field datatype ? it should be datetime.

parshdhage 13-Aug-12 4:21am

i was used Datetime datatype bt oracle 10g having INVALID MONTH error appear ..i changed it to DATE...and now its working..!

AmitGajjar 13-Aug-12 4:43am

are you passing DateTime object value in the query ?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Raj sinha · Accepted Answer · 2012-08-11T22:00:00

Solution 1

for inserting date in oracle you need to use to_date function. try this one.

SQL

insert into table_name
(date_field)
values
(to_date('2003/05/03 21:02:44', 'yyyy/mm/dd hh24:mi:ss'));

Raj

Posted 11-Aug-12 22:00pm

_Raj sinha

Comments

parshdhage 13-Aug-12 4:23am

thanxx for solution..!!

_Raj sinha 13-Aug-12 4:44am

if the solution works then vote for me and accept answer.