January 13th, 2012, 12:03 PM
|
|
Registered User
|
|
Join Date: Dec 2011
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
|
|
Quote:
Originally Posted by disel2010
Hi,
you should be able to insert two date fields in one insert statement.
Perhaps the order of your table fields is not matching up with the order you have in the insert statement?
Try specifying your columns to be sure. It should look like this then:
Code:
INSERT INTO member(column1, column2, column5, column8)
VALUES ('M102019', 'Adhe Nurcahya',to_date ('28-May-1992 ',' DD-MON-YYYY'),to_date ('12-dec-2011 ',' DD-MON-YYYY '));
|
thx disel.. I did get it yesterday.. 
It don't work bcause I haven't turned the nls_format_date..  |