SELECT
FullUrl AS 'Site URL', TimeCreated,
DATEADD
(d,DayLastAccessed + 65536, CONVERT(datetime, '1/1/1899', 101))
AS
lastAccessDate FROM Webs WHERE
(
DayLastAccessed <> 0) AND (FullUrl LIKE N'sites/%') ORDER BY lastAccessDate
FullUrl AS 'Site URL', TimeCreated,
DATEADD
(d,DayLastAccessed + 65536, CONVERT(datetime, '1/1/1899', 101))
AS
lastAccessDate FROM Webs WHERE
(
DayLastAccessed <> 0) AND (FullUrl LIKE N'sites/%') ORDER BY lastAccessDate
No comments:
Post a Comment