SQLTeam.com | Weblogs | Forums

Insert hire date with user format

i want to insert hiredate as , 'DD-MON-YYYY' format what copuld the sql statement.

INSERT INTO EMP VALUES (7369, 'SMITH', 'CLERK', 7902, TO_DATE('17-DEC-1980', 'DD-MON-YYYY'), 800, NULL, 20);

That looks like a MySql function call. This is a SQL server forum. You'd probably have better luck in a mysql forum