Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to "Update" a Date field 2

Status
Not open for further replies.
byrne1

byrne1

Programmer
Aug 7, 2001
415
US
I try to run an update at the control center to update a date field in a table using the sql statement "update custrel set dtndateofbirth=2/8/67 where customernum=80194565" but I gat the following error message:

"Incompatible types in column assignment list"

I've tried different formats for the date field including "yyyy/mm/dd", "yyyy-mm-dd", "mm-dd-yy" but none have worked.

What am I doing wrong?
 
Sort by date Sort by votes
You should use:
update custrel set dtndateofbirth='1967-02-08' where customernum=80194565"
THe format is:
'yyyy-mm-dd'
The Single quotes are critical.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
How to Execute Create View code in Actian Zen?
Replies
1
Views
527
mirtheil
mirtheil
profoundhypnotic
  • Locked
  • Question
How to read a csv file in Pervasive?
Replies
1
Views
583
mirtheil
mirtheil
profoundhypnotic
  • Locked
  • Question
how to select min and max value and the date for each
Replies
1
Views
528
mirtheil
mirtheil
michellepace
  • Locked
  • Question
Left Outer join returning "Unknown Error -19"
Replies
6
Views
592
mirtheil
mirtheil
Ino Mart
  • Locked
  • Question
How to use a variable as table name in a procedure 1
Replies
2
Views
445
Ino Mart
Ino Mart

Part and Inventory Search

Sponsor

Back
Top