WebFaction
Community site: login faq

SELECT UNIX_TIMESTAMP('2012-11-26 21:30:00') shows 1353945600 on my phpMyAdmin but on https://web323.webfaction.com/static/phpMyAdmin/ it shows 1353987000 How come this difference ?

asked 18 Nov '12, 07:10

epqrs
16921433
accept rate: 0%


The answer can depend on what timezone that your are working with. It appears that your working with UTC on your local machine and Web323 is operating on CST.

You can set your MySQL timezone on Web323 per connection by adding "set time_zone = '-6:00';" to the connection. Just make sure you are using the date/time functions on the same connection that you set the timezone on.

permanent link

answered 18 Nov '12, 08:11

aaront ♦♦
7664
accept rate: 27%

I am on IST. Thanks.

(18 Nov '12, 09:14) epqrs
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×168

question asked: 18 Nov '12, 07:10

question was seen: 2,606 times

last updated: 18 Nov '12, 09:14

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2020 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM