bach Posted May 20, 2006 Share Posted May 20, 2006 Hello,Wonder if you can help. I am looking at the data type of the dateRegistered field for a form script I have got they are using int(10) why ?? why not date ??Confusing me.Cheers. Quote Link to comment https://forums.phpfreaks.com/topic/10080-data-type-query/ Share on other sites More sharing options...
fenway Posted May 20, 2006 Share Posted May 20, 2006 Shouldn't be... dates should always be stored as DATEs. I guess you could get away with storing a timestamp value in a numeric field, but that's a bad idea. Quote Link to comment https://forums.phpfreaks.com/topic/10080-data-type-query/#findComment-37510 Share on other sites More sharing options...
bach Posted May 21, 2006 Author Share Posted May 21, 2006 I was under the sam impression, if there isn't a good reason then I will use a date field for mine.The forum software was [a href=\"http://www.simplemachines.org/\" target=\"_blank\"]Simple Machine Forum[/a]Cheers. Quote Link to comment https://forums.phpfreaks.com/topic/10080-data-type-query/#findComment-37649 Share on other sites More sharing options...
fenway Posted May 21, 2006 Share Posted May 21, 2006 You might want to use a DATETIME -- no reason to throw out half the information. Quote Link to comment https://forums.phpfreaks.com/topic/10080-data-type-query/#findComment-37711 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.