personally, since you have integers, i'd stick with using the dATEADD() functions:

/*

2012-02-01 00:00:00.000

2012-03-01 00:00:00.000

2012-04-01 00:00:00.000

*/

CREATE TABLE PS_TestForOnline

(

DAY_ INT,

MONTH_ INT,

YEAR_ INT

);

INSERT INTO PS_TestForOnline

VALUES(1,1,2012);

INSERT INTO PS_TestForOnline

VALUES(1,2,2012);

INSERT INTO PS_TestForOnline

VALUES(1,3,2012);

SELECT DATEADD(dd,DAY_ -1,

DATEADD(mm,MONTH_ -1,

DATEADD(yy,(YEAR_ - 1900) ,0))),

* FROM PS_TestForOnline