graham23s Posted July 21, 2007 Share Posted July 21, 2007 Hi GUys, on my registration form and in mysql i usually have 3 seperate fields: birthyear/birthday/birthmonth when it comes to storing the info into mysql is it best to store all 3 seperately or make it like: 0000-00-00 in the 1 field? thanks for any advice Graham Quote Link to comment Share on other sites More sharing options...
Wuhtzu Posted July 21, 2007 Share Posted July 21, 2007 If all birthdays were after 1970 I would definitely use a timestamp but since they don't and I've heard about problems with negative timestamps i would go for the yyyy-mm-dd which mysql can "manipulate" with in queries... Quote Link to comment Share on other sites More sharing options...
graham23s Posted July 21, 2007 Author Share Posted July 21, 2007 nice one, thanks mate Graham Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.