nezbo Posted February 3, 2009 Share Posted February 3, 2009 I have this code (day(et.receiveStart) + month(et.receiveStart) + year(et.receiveStart)) AS 'Receive call started Date', It makes a whole number e.g. 2013 i am trying to get date of 03/02/2009 i am not to sure how to do this. Nezbo Link to comment https://forums.phpfreaks.com/topic/143597-adding-numbers-to-form-a-date/ Share on other sites More sharing options...
corbin Posted February 4, 2009 Share Posted February 4, 2009 CONCAT might work. Link to comment https://forums.phpfreaks.com/topic/143597-adding-numbers-to-form-a-date/#findComment-754056 Share on other sites More sharing options...
nezbo Posted February 4, 2009 Author Share Posted February 4, 2009 I have tried CONCAT and it don't work with SQL Server. Cheers, Anyway Nezbo Link to comment https://forums.phpfreaks.com/topic/143597-adding-numbers-to-form-a-date/#findComment-754174 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.