shan_cool Posted January 3, 2006 Share Posted January 3, 2006 Hi all, I want to convert Date to numbers using a select statement,I want to calculate the experience of a company ie Current date minus the Date of join how can i do it using a select statement.... Can anyone help, Thks, Shan Link to comment https://forums.phpfreaks.com/topic/3135-converting-date-to-numbers/ Share on other sites More sharing options...
fenway Posted January 3, 2006 Share Posted January 3, 2006 "convert Date to numbers"? What do you mean by this? What numbers? You can easily use DATEDIFF() to find out the days elapsed beteen two MySQL dates, if that's what you mean by "calculate the experience of a company". Please clarify. Link to comment https://forums.phpfreaks.com/topic/3135-converting-date-to-numbers/#findComment-10545 Share on other sites More sharing options...
shan_cool Posted January 4, 2006 Author Share Posted January 4, 2006 Hi, Thks for your reply,I used DateDiff its wrking Now.. Thks, Shan Link to comment https://forums.phpfreaks.com/topic/3135-converting-date-to-numbers/#findComment-10591 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.