Hello, I have one query with timestamp. I got below error. select users.login, FROM_UNIXTIME(AVG(UNIX_TIMESTAMP(ticket_history.create_time)-UNIX_TIMESTAMP(ticket.create_time))) from ticket_history_type inner join ticket_history on ticket_history.history_type_id=ticket_history_type.id inner join ticket on ticket.id = ticket_history.ticket_id inner join users on users.id = ticket_history.change_by where ticket.create_time BETWEEN '2014-10-01' AND '2014-10-15' AND ticket_history.name ='%%new%%Fermeture réussie%%' group by users.id *`error: function unix_timestamp(timestamp without time zone) does not exist`* Thanks in advanced for your input.

Member Avatar
Member Avatar
+0 forum 8

My web host recently migrated to a new server and in the process upgraded to PHP5.4 I have a snippet that was doing timezone conversion, but since the upgrade the script stops dead on a certain line in the snippet, and though a web page is displayed, none of the content (including html) displays beyond that PHP line. Here is the code with the problem lines commented out: <?php $timestamp = strtotime($create); $dtzone = new DateTimeZone($tz); $time = date('r', $timestamp); /* Problem code begins here $dtime = new DateTime($time); $dtime->setTimeZone($dtzone); $time = $dtime->format('F d, Y'); Problem code ends here*/ echo …

Member Avatar
Member Avatar
+0 forum 21

Guys, please let me know is anybody aware of the below doubt. php taking hosting server date and time but am in need to find the client time and date who accesing the site. otherwise how to find the date & time in server time zone .

Member Avatar
Member Avatar
+0 forum 7

Hi , Can anyone tell how I will send the local time zone to the server and so that I can convert the unix time(coming from the database) to the local time and display it on the clients side using php (In short I dont want to use javascript when I display the time) This is how I saved the time to database: - **Javascript** var exp_day = $("#exp_day").val(); if ( (exp_day == 0) || (exp_day == "") ) { exp_day = 00; } else { exp_day= parseInt($("#exp_day").val()); } var exp_hrs = $("#exp_hrs").val(); if ( (exp_hrs == 0) || (exp_hrs …

Member Avatar
Member Avatar
+0 forum 1

hey guys... just wanna ask, is setting timezone on php automatically computes for daylight saving times? i mean does it autmatically detect DST and automaticaly add +1 hour on specific month? thanks in advance

Member Avatar
Member Avatar
+0 forum 4

hey guys.... anyone here know why my time here in localhost is different from the internet, let's say even though i already set my timezone to "America/New_York" the time is still different

Member Avatar
Member Avatar
+0 forum 4

i want a design and develop a web page which will show the current time on the basis of the request. eg if the request of the page is come from dubai then the server automaticaly finds the current time of dubai and writes that time on the page. similarly if the request comes from india then the server aoutomatically finds the curent time of india and write that time on the page before sending that page to the client????

Member Avatar
Member Avatar
+0 forum 4

Hi All!!! im currently at a roadblock in my knowledge of using mysql and php date/time functions. the program i am trying to write, needs to incoporate the current date in the mysql query to pull the correct information to display in real-time.. currently the server is on east coast time, and the program will be based on Arizona time... beyond changing the php.ini file for php what can i do client side to remedy this... thanks again for your ideas!!!!

Member Avatar
Member Avatar
+0 forum 3

Hi I am using a script similar to Scriptlance which is using the server time to datestamp everything and display dates and times of the start and end of projects. The problem is that the server is in the US running on PDT time and I am in the UK running on GMT time. Is there a way that I can globally declare for the script that each time (no pun intended) that the time() function is used it is the GMT timezone or offset it by a fixed amount? I don't fancy having to go through the whole script …

Member Avatar
Member Avatar
+0 forum 2

I am building a website with a forum that I am building myself. I just don't know how to let the user change their time zone. My server time zone is my time zone ([B]date_default_timezone_set('Europe/London');[/B]). Please could I have some help with this. Thanks in advance, Cameron

Member Avatar
Member Avatar
+0 forum 1

The End.