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
Lowell