ted_chou12 Posted January 1, 2007 Share Posted January 1, 2007 what type should i choose for time offset? time or int?ThanksTed Quote 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. Quote 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 Quote 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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.