Re: [PHP] Query based on Server offset TimeStamp

2009-11-23 Thread Philip Thompson
On Nov 23, 2009, at 7:37 PM, Don Wieland wrote: > Hello, > > I have a mySQL database server in Florida USA (EST) and I want to do a query > on a record in California, USA (PST) 3 hours earlier using PST instead of EST. > > I would like to add to my CORE page that offset of the timezone so I can

[PHP] Query based on Server offset TimeStamp

2009-11-23 Thread Don Wieland
Hello, I have a mySQL database server in Florida USA (EST) and I want to do a query on a record in California, USA (PST) 3 hours earlier using PST instead of EST. I would like to add to my CORE page that offset of the timezone so I can use it in a query like: Select * FROM aTable WHERE