Jump to content


Photo

format a date


  • Please log in to reply
1 reply to this topic

#1 9911782

9911782
  • Members
  • PipPipPip
  • Advanced Member
  • 39 posts

Posted 16 August 2006 - 10:20 AM

Hi All

I need to format 2006/07(2006/2007, 2007/2008)field in my database. Do I need to use the year datatype? The problem is that, I have a list of objectives that will run for those 2 specific years. I am really out...I have use the varchar(8), but Im so sure that, Its not right.

And How do I return only a year in the above mentioned date?
Please help me.
thank you ???


#2 fenway

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

Posted 16 August 2006 - 03:58 PM

I'm not sure I understand... you want to store two years in the same column?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users