如何将下面的oracle的sql 语句转换成sql server的sql 语句

[qjhaaaaa]

CREATE OR REPLACE VIEW RESOURCEDATETYPETIMEVIEW AS
SELECT
nResourceID,sDateTypeName,nDateTypeType,nDateTypeID,
to_date(sDate, 'yyyy-mm-dd') as dtDate,
SUM(dWork) as dWork
FROM
(SELECT
Timesheet.nResourceID as nResourceID,
to_char(Timesheet.dtDate, 'yyyy-mm-dd') as sDate,
SUM(Timesheet.dHours) as dWork,
datetype.sname as sDatetypeName,
dateType.ntype as nDateTypeType,
datetype.id as nDateTypeID
FROM
Timesheet, DateType
WHERE
Timesheet.nDateTypeID = DateType.ID
GROUP BY datetype.ntype,datetype.id,datetype.sname,Timesheet.nResourceID, to_char(Timesheet.dtDate, 'yyyy-mm-dd'))
GROUP BY nDateTypeType,nDateTypeID,sDateTypeName,nResourceID, sDate
请问如何转换成sql server 的sql 语句

[愉快的登山者]

CREATE VIEW RESOURCEDATETYPETIMEVIEW AS
SELECT
nResourceID,sDateTypeName,nDateTypeType,nDateTypeID,
convert(char(10), sDate, 120) as dtDate,
SUM(dWork) as dWork
FROM
(SELECT
Timesheet.nResourceID as nResourceID,
convert(char(10), Timesheet.dtDate, 120) as sDate,
SUM(Timesheet.dHours) as dWork,
datetype.sname as sDatetypeName,
dateType.ntype as nDateTypeType,
datetype.id as nDateTypeID
FROM
Timesheet, DateType
WHERE
Timesheet.nDateTypeID = DateType.ID
GROUP BY datetype.ntype,datetype.id,datetype.sname,Timesheet.nResourceID, convert(char(10), Timesheet.dtDate, 120))
GROUP BY nDateTypeType,nDateTypeID,sDateTypeName,nResourceID, sDate