Ask a Question
Advertise on boostr.in
Organizational Research By
Surprising Reserch Topic
storing day and month without year using -'mysql,database-design'
storing day and month without year ¬†using -'mysql,database-design'
I'm having trouble with figuring out the best way to store some data in my database. I've got to store DD/MM dates in a database, but I'm not sure of the best way to store this so that it can be easily sorted and searched.
Basically a user will be able to save important dates in the format DD/MM, which they will be reminded of closer to the day.
The DATE data type doesn't seem completely appropriate as it includes year, but I can't think of another way of storing this data. It would be possible to include a specific year to the end of all occasions, but this almost doesn't seem right.
Sep 7, 2015
to add a comment.
Related Hot Questions
Government Jobs Opening