OracleErrorData

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS

Q&A for administrators, end users, developers and designers for Craft CMS

select top 1000 
t.Id,t.PostTypeId
,t.AcceptedAnswerId
,FORMAT(t.CreationDate,'dd-MM-yyyy') AS creationDate
,FORMAT(GETDATE(),'dd-MM-yyyy') AS CurrentDate
,DATEDIFF(day,t.CreationDate,GETDATE()) as Days
,t.Score
,t.ViewCount
,t.Body
,LastActivityDate
,t.Title
,t.Tags
,t.AnswerCount
,t.CommentCount
 from posts t
where t.tags like '%oracle%'
and t.title like '%error%'
and t.score>0

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results