View Single Post
  #2 (permalink)  
Old January 10th, 2012, 08:55 AM
disel2010 disel2010 is offline
Authorized User
Points: 448, Level: 7
Points: 448, Level: 7 Points: 448, Level: 7 Points: 448, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2011
Posts: 85
Thanks: 1
Thanked 12 Times in 12 Posts
Default

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 '));
Reply With Quote
The Following User Says Thank You to disel2010 For This Useful Post:
adhe2chazper (January 13th, 2012)