[Rails] Re: Storing just the year in the DB

2009-02-22 Thread Sazima
Scott, Why don't you use the default created/updated_at fields and just format the output to present only the year? Cheers, Sazima On Feb 20, 8:02 pm, Scott Holland rails-mailing-l...@andreas-s.net wrote: Hey, This may be a simple question, but I just wanted to make sure I was doing it

[Rails] Re: Storing just the year in the DB

2009-02-22 Thread Maurício Linhares
Store it as an integer, this will surely help you once you need to query it. - Maurício Linhares http://alinhavado.wordpress.com/ (pt-br) | http://blog.codevader.com/ (en) On Fri, Feb 20, 2009 at 8:02 PM, Scott Holland rails-mailing-l...@andreas-s.net wrote: Hey, This may be a simple

[Rails] Re: Storing just the year in the DB

2009-02-21 Thread Miguel Regedor
I don't see a big advantage in storing it as a date, if you only want to store the year why not store it as an integer? if then you need to do some calculations you can always convert it to whatever you want. On Feb 20, 11:56 pm, Scott Holland rails-mailing-l...@andreas-s.net wrote: CiriusMex

[Rails] Re: Storing just the year in the DB

2009-02-20 Thread CiriusMex
Well actualy it depends a lot on what you wanna do with this year data...could you precise a little what is your goal? On 20 feb, 17:02, Scott Holland rails-mailing-l...@andreas-s.net wrote: Hey, This may be a simple question, but I just wanted to make sure I was doing it right. I need to

[Rails] Re: Storing just the year in the DB

2009-02-20 Thread Scott Holland
CiriusMex wrote: Well actualy it depends a lot on what you wanna do with this year data...could you precise a little what is your goal? On 20 feb, 17:02, Scott Holland rails-mailing-l...@andreas-s.net I am building a little application to manage our company holiday entitlement. When

[Rails] Re: Storing just the year in the DB

2009-02-20 Thread CiriusMex
Ok, so the year will just be stored as information (I mean you'll just use it to display the information on a page) no? If it's like that you store it as a varchar or integer I think. But if you will need to process the year in other functions well it should be better to store it as a year. When

[Rails] Re: Storing just the year in the DB

2009-02-20 Thread Scott Holland
CiriusMex wrote: Ok, so the year will just be stored as information (I mean you'll just use it to display the information on a page) no? If it's like that you store it as a varchar or integer I think. But if you will need to process the year in other functions well it should be better to

[Rails] Re: Storing just the year in the DB

2009-02-20 Thread Philip Hallstrom
CiriusMex wrote: Ok, so the year will just be stored as information (I mean you'll just use it to display the information on a page) no? If it's like that you store it as a varchar or integer I think. But if you will need to process the year in other functions well it should be

[Rails] Re: Storing just the year in the DB

2009-02-20 Thread CiriusMex
Actually if you gonna use the date to make some things you can store it as a simple integer, or as a date but not with 0 as day and month but 1 as 0 is no month or day ^^ On 20 feb, 18:12, Philip Hallstrom phi...@pjkh.com wrote: CiriusMex wrote: Ok, so the year will just be stored as