DATE_FORMAT results in error

Vote count:

0

In SQL+, I am trying to insert a date with the year, month, day, day of the week, hour, minute, and second. Everything went as expected except for the day of the week. The original insert statement excluded the day of the week and ran perfectly

insert into auctions 
values (To_Date('AUGUST 12, 2014 11:01:02','MONTH DD, YYYY HH:MI:SS'));

however, when I attempt to include the day of the week I get an error

insert into auctions 
values (To_Date('TUE AUGUST 12, 2014 11:01:02','WTXT MONTH DD, YYYY HH:MI:SS'));

ORA-01820: format code cannot appear in date input format

Obviously I'm doing something wrong, probably the syntax of WTXT. The goal is to have the day of the week in three letter abbreviated form. What is the problem?

asked 1 min ago

TechSavvySmurf

20