SQLTeam.com | Weblogs | Forums

Insert hire date with user format


#1

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);


#2

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