MSSQL support for archive view

The Views module provide a default page and block to display archive. The data sort using month and year and also show counting of node in the month and year.

The module provide query compatible to MySQL, pgsql, Sqlite only. In order to use views with MSSQL module should provide compatible query.

Here is small addition in "views_date_sql_field" function code that it can be use with MSSQL. There is lot of line of code that should be add in addition work views with MSSQL.

function views_date_sql_field($field, $field_type = 'int', $set_offset = NULL) {
$db_type = Database::getConnection()->databaseType();
$offset = $set_offset !== NULL ? $set_offset : views_get_timezone();
if (isset($offset) && !is_numeric($offset)) {
$dtz = new DateTimeZone($offset);
$dt = new DateTime("now", $dtz);
$offset_seconds = $dtz->getOffset($dt);
}

switch ($db_type) {
case 'sqlsrv':
switch ($field_type) {
case 'int':
$field = "DATEADD(second, $field, '1970-01-01')"; //DATEADD(second, @timestamp,{d '1970-01-01'});
break;
case 'datetime':
break;
}
if (!empty($offset)) {
$field = "DATEADD(second, $offset_seconds, $field)"; //"($field + INTERVAL $offset_seconds SECOND)";
}
return $field;
case 'mysql':
switch ($field_type) {
case 'int':
$field = "DATE_ADD('19700101', INTERVAL $field SECOND)";
break;
case 'datetime':
break;
}
if (!empty($offset)) {
$field = "($field + INTERVAL $offset_seconds SECOND)";
}
return $field;