| Код |
SELECT m.id, m.from_id, CONCAT( pfrom.lastname, ' ', pfrom.name, ' ', pfrom.surname ) AS name_from, m.to_id, CONCAT( pto.lastname, ' ', pto.name, ' ', pto.surname ) AS name_to, m.title, m.text, m.send_date, m.receive_date
FROM Messages m
INNER JOIN Person pfrom ON pfrom.id = m.from_id
INNER JOIN Person pto ON pto.id = m.to_id
WHERE STR_TO_DATE('2010-11-01 17:25:44', '%Y-%m-%d %H:%i:%s') > STR_TO_DATE(03.11.2010 19:34:38, '%d.%m.%Y %H:%i:%s')
|
ругается на WHERE STR_TO_DATE('2010-11-01 17:25:44', '%Y-%m-%d %H:%i:%s') > STR_TO_DATE(03.11.2010 19:34:38, '%d.%m.%Y %H:%i:%s')
| Цитата |
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.2010 19:34:38, '%d.%m.%Y %H:%i:%s')' at line 5
|
|