Advertisement
krot

BETWEEN STR_TO_DATE

Jun 22nd, 2017
258
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.27 KB | None | 0 0
  1. SELECT sh.*,c.`City` FROM `oe_shipment` sh
  2. JOIN `os_city` c on c.`ID`=sh.`idCity`
  3. WHERE  sh.`idCity`=7 AND sh.`udate` BETWEEN STR_TO_DATE('2017-06-01 00:00:00', '%Y-%m-%d %H:%i:%s')
  4.   AND STR_TO_DATE('2017-06-22 23:59:59', '%Y-%m-%d %H:%i:%s') ORDER BY sh.`ID` DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement