Код: Выделить всё
SELECT ID, VALUE, UNIX_TIMESTAMP(ADDED) as UNX FROM phistory WHERE VALUE_ID='366' AND ADDED>=('2016-02-06 08:30:00') AND ADDED<=('2016-02-06 15:30:00') ORDER BY ADDED
Модератор: immortal
Код: Выделить всё
SELECT ID, VALUE, UNIX_TIMESTAMP(ADDED) as UNX FROM phistory WHERE VALUE_ID='366' AND ADDED>=('2016-02-06 08:30:00') AND ADDED<=('2016-02-06 15:30:00') ORDER BY ADDED
Код: Выделить всё
SELECT ID, VALUE, UNIX_TIMESTAMP(ADDED) as UNX FROM phistory WHERE VALUE_ID='409' AND ADDED>=('2016-02-26 08:30:00') AND ADDED<=('2016-02-26 15:30:00') ORDER BY ADDED
Код: Выделить всё
Fri Feb 26 13:07:06 IST 2016
Код: Выделить всё
Current default time zone: 'Asia/Jerusalem'
Local time is now: Fri Feb 26 13:06:36 IST 2016.
Universal Time is now: Fri Feb 26 11:06:36 UTC 2016.
Код: Выделить всё
SELECT ID, VALUE, ADDED FROM phistory WHERE VALUE_ID='409' AND ADDED>=('2016-02-26 08:30:00') AND ADDED<=('2016-02-26 15:30:00') ORDER BY ADDED
Код: Выделить всё
DebMes("pChart2: end_time = ".$end_time);
Код: Выделить всё
SELECT ID, VALUE, UNIX_TIMESTAMP(ADDED) as UNX FROM phistory WHERE VALUE_ID='409' AND ADDED>=('2016-02-26 13:30:00') AND ADDED<=('2016-02-26 18:30:00') ORDER BY ADDED
Код: Выделить всё
SELECT ID, VALUE, ADDED FROM phistory WHERE VALUE_ID='409' AND ADDED>=('2016-02-26 13:30:00') AND ADDED<=('2016-02-26 18:30:00') ORDER BY ADDED