Jump to content

Archived

This topic is now archived and is closed to further replies.

shan_cool

Converting Date to Numbers

Recommended Posts

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

Share this post


Link to post
Share on other sites

"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.

Share this post


Link to post
Share on other sites

Hi,

 

Thks for your reply,I used DateDiff its wrking Now..

 

Thks,

Shan

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.