ted_chou12 Posted January 1, 2007 Share Posted January 1, 2007 what type should i choose for time offset? time or int?ThanksTed Link to comment https://forums.phpfreaks.com/topic/32453-solved-how-should-time-off-set-be-stored-in-mysql-data/ Share on other sites More sharing options...
trq Posted January 1, 2007 Share Posted January 1, 2007 Assuming you meen so you can offset a users timezone then you'll be storing an integer so int. Link to comment https://forums.phpfreaks.com/topic/32453-solved-how-should-time-off-set-be-stored-in-mysql-data/#findComment-150788 Share on other sites More sharing options...
ted_chou12 Posted January 1, 2007 Author Share Posted January 1, 2007 okay, thanks Link to comment https://forums.phpfreaks.com/topic/32453-solved-how-should-time-off-set-be-stored-in-mysql-data/#findComment-150789 Share on other sites More sharing options...
ted_chou12 Posted January 1, 2007 Author Share Posted January 1, 2007 by the way, would INT be enough to store the time offset? or you need more or less space? Please specify the number of maximum digits required for time offset. ThanksTed Link to comment https://forums.phpfreaks.com/topic/32453-solved-how-should-time-off-set-be-stored-in-mysql-data/#findComment-151057 Share on other sites More sharing options...
Jessica Posted January 1, 2007 Share Posted January 1, 2007 What do you think it would be? How many hours can there possibly be offset? How many digits is that? If you're storing it like 1 hour offset, 2 hours, etc, don't you think it's kind of obvious what the maximum is?If you're storing it another way, please explain. Link to comment https://forums.phpfreaks.com/topic/32453-solved-how-should-time-off-set-be-stored-in-mysql-data/#findComment-151063 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.