Jump to content


Photo

Converting Date to Numbers


  • Please log in to reply
2 replies to this topic

#1 shan_cool

shan_cool
  • Members
  • PipPipPip
  • Advanced Member
  • 53 posts
  • LocationChennai,India

Posted 03 January 2006 - 03:41 AM

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

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 03 January 2006 - 09:18 AM

"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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 shan_cool

shan_cool
  • Members
  • PipPipPip
  • Advanced Member
  • 53 posts
  • LocationChennai,India

Posted 04 January 2006 - 04:07 AM

Hi,

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

Thks,
Shan




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users