SELECT OBJID,NAME,CONVERT(varchar(19), CREATIONDATE, 120) AS CREATIONDATE
FROM [dbo].[SYS_DOCUMENTREV]
WHERE NAME LIKE 'test%.pdf'
ORDER BY CREATIONDATE DESC
SELECT OBJID,NAME,CONVERT(varchar(19), CREATIONDATE, 120) AS CREATIONDATE
FROM [dbo].[SYS_DOCUMENTREV]
WHERE NAME LIKE 'test%.pdf'
ORDER BY CREATIONDATE DESC