| Invalid Month Problem [message #20735] |
Sun, 16 June 2002 17:53  |
Cheesy
Messages: 1
Registered: June 2002
|
Junior Member |
|
|
Hi all,
I'm trying to insert date to table,
I have this error :
Invalid Month problems..
I know that it might caught wrong by the Oracle DBMS about the field inserted..
I've read .. but have forget how the solution...
Insert into tab_a values (#....#)
yes.. i think i've seen it... but can't remember the full direction..
so Please... somebody who actually knows the solution.. please let me know too..
thanks
|
|
|
|
| Re: Invalid Month Problem [message #20736 is a reply to message #20735] |
Sun, 16 June 2002 18:33  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
default date format is dd-mon-yy
HIGH9I: MAG> insert into tdate values ('10-jan-90');
1 row created.
HIGH9I: MAG> ed
Wrote file afiedt.buf
1* insert into tdate values ('10-jan-1990')
HIGH9I: MAG> /
1 row created.
HIGH9I: MAG> select * from tdate;
D
---------
10-JAN-90
10-JAN-90
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
