UNIX + nginx + php + SQL

manpreet Best Answer 2 years ago

I use a FTP site to upload my work, which resides on a server running on a Linux OS based on nginx. And I use an odbc driver to connect to a database that interacts with my php code. In that database exists a date column type that returns the full date & time. I need to retrieve just the date. I used the CONVERT function convert(varchar(10), date_col, 110)and get the needed result using it withAptanaStudio as my IDE. But my php code returns an empty field. What have I done wrong? The code:

Date is:
                                             





   

manpreet 2 years ago

So I used dancing with PHP code, and got the solution

$r['rep_date'] = mb_substr(strval($r['rep_date']), 0, 10, 'UTF-8');