CodeIgniter Forums

Full Version: Problems with datetime field in mssql
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

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

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

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

But CI script gets back that:
[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.