How to Set datetime format when use MSSQL? (default: 2011-05-11 00:04:26.000, I want to show: 2011-05-11 00:04:26

Yii 1.1 General Discussion
1

Hello All!

How to Set datetime format when use MSSQL?

now, the result show : 2011-05-11 00:04:26.000,

I want to show format: 2011-05-11 00:04:26

Thanks!

2

You can create a getter function in the method for format the date.

Take also a look at the class CDateFormatter, there are lot of useful methods for work with dates.

3

I think that PHP or MSSQL have some param can do this.

Thanks!