Query based on Server offset TimeStamp
| From: | Don Wieland | 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