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 Quote Link to comment 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. Quote Link to comment 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 Quote Link to comment 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.