-
Working with Dates in Sql
I created a table (jftest) with three fields as follows:
account char(10)
ckey varchar(25)
cmpdate date
I can insert datat into the account and ckey fields no problem. But I can not inert data into the cmpdate field. What is the correct syntax?
I also tried to Update the field with the following:
Code:
update jftest set cmpdate=to_date('4/19/2006', 'mm/dd/yyyy');
but get an error as well.
what is the correct syntax for updating date fields?
-
-
I was using the tutorial on this site.
-
rmaio was asking you if you are using Microsoft SQL Server, Oracle, DB2, Microsoft Access, etc.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|