new answers from the last 48 hours

0

Please login or register to vote for this query.

(click on this box to dismiss)

Magento

Q&A for users of the Magento e-Commerce platform

SELECT
    a.Id AS [Post Link],
    DATEDIFF(hour, a.CreationDate, GETDATE()) AS [Time Difference], a.CreationDate

FROM
    Posts a INNER JOIN Posts q ON a.ParentId = q.Id

WHERE
DATEDIFF(hour, a.CreationDate, GETDATE()) <= 48

ORDER BY
a.CreationDate DESC

Enter Parameters

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