Elapsed time twitter like

[RFH Customer: terraqueotenaz]

Hi there,

how can I emulate the twitter like function: my tweet 5 minutes ago.

I´m usign a database to retreive the date of a post. I want to display the elapsed time.

Using datediff()??

thank you.

[RFH Reseller: balexandre]

SELECT
[whatever]
FROM
[your table]
WHERE
datediff(mi, [your date/Time column], getdate()) <= 5;

SQL DateDiff function