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 Quote 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. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.