Hello,

Code:
<?php
$query="SELECT * FROM sms_logs 
           WHERE empno='$empno' 
           AND STR_TO_DATE(LEFT(date,10),'%Y/%m/%d')=....";
?>
my question is, the first parameter LEFT(date,10) of STR_TO_DATE() need to be enclosed by 's ?