noob : advice on design?

2005-07-06 Thread Monty Harris
Dear Group, I have just completed the Sams MySQL in 24 hours and feel like I now have a reasonable understanding of creatinf queries, etc. However, the one area that seemed sadly lacking was that of database design. I recently purchased a book named "Database design for mere mortals", which seems

Re: time zones

2005-04-28 Thread Monty Harris
> How does one cope with time zones? For example, if I want to timestamp a > record it will timestanp using the local time of my server. I thought that, > e.g if my server was in New York and my customer_location was the UK, I can > just add 5 hours to the time and it would be correct. > While th

time zones

2005-04-27 Thread Monty Harris
How does one cope with time zones? For example, if I want to timestamp a record it will timestanp using the local time of my server. I thought that, e.g if my server was in New York and my customer_location was the UK, I can just add 5 hours to the time and it would be correct. While that might