You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!
If you have any problems with the registration process or your account login, please contact contact support.
If you prefer not to see double-underlined words and corresponding ads, place your cursor
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
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')
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.