[ASK] CDbExpression('NOW()');

Converting MySQL to MS-SQL. it was not that straight forwards than I thought;

one of the pieces broken was CDbExpression(‘NOW()’);

I know I could search and replace all, but would be nice if we have a generic function to handle this regardless what db is?


thought about create mssql function, however, syntax-wise i have to have [dbo].NOW() meaning code change anyway, so I come up this, might be useful solution to someone else?