CREATE TABLE DATELOG (DATE DATETIME,NAME VARCHAR(20)) --this is in mm-dd-yyyy formate save INSERT INTO DATELOG VALUES(CONVERT(datetime,'2/1/84'),'XXX') --this is in dd-mm-yyyy format not save INSERT INTO DATELOG VALUES(CONVERT(datetime,'22/1/84'),'XXX') SELECT * FROM DATELOG SELECT REPLACE(CONVERT(VARCHAR(13),DATE,105),'-','/') AS DATE FROM DATELOG ----------------------------------------------------------------------------
DATETIME
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)