I have a problem with insering a date into pervasive table.while i inserting date into my table it gives me an error calling invalid date,time or timestamp value.
Can any one tell me what is the correct format of insering a date in to a table

thanks

The format for a date is:
'yyyy-mm-dd'
You need the single quotes as well. For example:
insert into table (dateField) values ('2008-03-25')