MSYQL STR_TO_DATE

**afridy** · May 2, 2013 04:16

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 ?

**r937** · May 2, 2013 04:21

Originally Posted by afridy

my question is, the first parameter LEFT(date,10) of STR_TO_DATE() need to be enclosed by 's ?

what happened when you tested it? ™

**afridy** · May 2, 2013 04:37

Originally Posted by r937

what happened when you tested it? ™

could not see any different it seems

**r937** · May 2, 2013 05:38

Originally Posted by afridy

could not see any different it seems

o rly?

please show the actual query you ran with the quotes around LEFT(date,10)

**afridy** · May 4, 2013 00:00

Originally Posted by r937

o rly?

please show the actual query you ran with the quotes around LEFT(date,10)

I am sorry! just tested again and it does not have to be enclosed by '. if i did , then no out put (no errors shown though).
tx r937

User Tag List