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. 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. 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. 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. Link to comment https://forums.phpfreaks.com/topic/10080-data-type-query/#findComment-37711 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.