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

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!

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.

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

Thanks!