Query based on Server offset TimeStamp

From: Date: Tue, 24 Nov 2009 01:37:57 +0000
Subject: Query based on Server offset TimeStamp
Groups: php.general 
Request: Send a blank email to php-general+get-300042@lists.php.net to get a copy of this message
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 ServerOffsetTimeStap >= Row_Start_TimeStamp AND ServerOffsetTimeStap <= Row_End_TimeStamp How would I do this? Appreciate any help you can offer. Thanks! Don Wieland D W D a t a C o n c e p t s ~~~~~~~~~~~~~~~~~~~~~~~~~ donw@dwdataconcepts.com Direct Line - (949) 305-2771 Integrated data solutions to fit your business needs. Need assistance in dialing in your FileMaker solution? Check out our Developer Support Plan at: http://www.dwdataconcepts.com/DevSup.html Appointment 1.0v9 - Powerful Appointment Scheduling for FileMaker Pro 9 or higher http://www.appointment10.com For a quick overview - http://www.appointment10.com/Appt10_Promo/Overview.html

« previous php.general (#300042) next »