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 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 creating a new line on your database you can use the Date.today > >> function to get the current date, after the function strftime will > >> help you to display only the year: > >> @year = <your_object>.year.strftime("%Y") > > >> displaying @year in your html.erb page you'll only see the year from > >> the date, just as you want to. > > >> On 20 feb, 17:32, Scott Holland <rails-mailing-l...@andreas-s.net> > > > Thank you for the reply. > > > I am going to use the year to calculate other things. > > > So will it be ok to leave the the day and the month as '0' in the > > 'date' > > format? > > > 2008-00-00 > > I wouldn't. Mysql doesn't seem to care. PostgreSQL does. > > philip=# create table foo (d date); > CREATE TABLE > philip=# insert into foo values ('2008-00-00'); > ERROR: date/time field value out of range: "2008-00-00" > HINT: Perhaps you need a different "datestyle" setting.- Ocultar texto de la > cita - > > - Mostrar texto de la cita - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---