Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Time Function incorrect

Time Function incorrect

Thread began 2/19/2011 11:48 pm by reseller218363 | Last modified 2/20/2011 3:26 pm by reseller218363 | 1867 views | 2 replies |

2/19/2011 11:48 pm | #1 reseller218363

Time Function incorrect

I'm currently testing a sport schedule website. the site is working geat. However, I'm The time function of the website is not working. The database consists of two fields. Date and Time. The date element is working Okay, only the time field that has the problem.

I want to be able to insert time into the database base on time zone with EST the Default time zone. Currently when I Insert time into the database (ex. 04:30 PM) the result, and update page change the PM to am, and I'm not sure if the code for changing the time zone is working.

PS.

(Ray Borduin) had worked on this problem, however the problem is incomplete.
Scheduled Premier Appointment:
Ticket # 123060
Continuing Premier Ticket # 123479

2/20/2011 2:04 am | #2 Dave BuchholzBeta Tester

When you insert a date or time the local date / time zone of the server is used so for example if your server is in a region where the time is PST then that is the time zone used.

You can override this by placing this statement at the top of your page:

php:

/*

Set Timezone

---------------------------------------------------------- 

*/



ini_set('date.timezone', 'US/Eastern');

You can find a list of all the supported timezones here: timezones.php

Hope that helps

2/20/2011 3:26 pm | #3 reseller218363

Thanks Dave, for your quick reply

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.