10 Topics
|
|
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 … |
|
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 … |
|
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 … |
|
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 |
|
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 |
|
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 … |
|
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 … |
|
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 … |
|
|
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 |
The End.