MS SQL to MySQL select

Hello! In order for me to achive the goal of migrating a MS SQL based application to web based php / mysql I need to understand a little bit MS SQL syntax and MySQL counterpart expression. If is not too much to ask one of you guys could "translate" this MS SQL select to MySQL? Here's the challeng

RE: what is the proper way to store timezone information?

Boyd, Todd M. wrote: >> >> When recording this information, do I store the full name or just >> the 'time_zone_id' which is present in mysql.time_zone_name ? > > This is entirely a matter of choice. It's like asking if you should > store formatting when you insert phone numbers into a database--