Hello, Starting from the position that databases are a relic of the 1980s, and date/time/timezone fields are a persistent nightmare, don't use them. Store all your dates as a number of seconds or milliseconds since 1970 (ie epoch), and then display them appropriately. The timezone element is only ever relevant when rendering the date, and Mid Tier should know the user's timezone via a preference or the browser.
I've lost count of the number of projects I've been involved in where there are timezone hacks around daylight savings, etc. John _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
