November 20th, 1999, 06:39 AM
hi all
i am using vb5 with oracle as backend i am having problem with inserting a date value record in the table.
how ahould i write a insert statement to insert date field
i am posting my statement. please correct this.
insert into customerqry(cid,Billing_End_Date) values(1, '11/20/99')
cid is a number field and Billing_end_date is date field
It is a bit urgent
Thanx in advance
i am using vb5 with oracle as backend i am having problem with inserting a date value record in the table.
how ahould i write a insert statement to insert date field
i am posting my statement. please correct this.
insert into customerqry(cid,Billing_End_Date) values(1, '11/20/99')
cid is a number field and Billing_end_date is date field
It is a bit urgent
Thanx in advance