CodeIgniter Forums
Problems with datetime field in mssql - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forum-5.html)
+--- Forum: General Help (https://forum.codeigniter.com/forum-24.html)
+--- Thread: Problems with datetime field in mssql (/thread-65482.html)



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.