CodeIgniter Forums
Problems with datetime field in mssql - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Problems with datetime field in mssql (/showthread.php?tid=65482)



Problems with datetime field in mssql - -Lesnik- - 06-16-2016

Hi.

I have a mssql DB with table that has a field 'date' of datetime type.

And the problem is the result of query:
Code:
select date from table

If i'm using a 'native php' to get this field, i have smth like that:
Code:
[date] => 2016-06-09 16:18:39.450

But CI script gets back that:
Code:
[date] => Jun  9 2016 04:18:39:450PM

So i want to make CI get back result like 'native php'. Or understand where from that difference.

Sorry for my English.