Outputting date desciptions from datetime field

[chrissparkle]

I would like to output messages from my select statement in my proc based on the value in my datetime field. ideally I'd like to check if the date in the field is less than 30 mins from now then say "X minutes ago", if it's more then i say "Less than 1 hour ago", more than 1 hour i say "X hours" etc etc .

Is this possible from within the select statement?

 

[harebrain]

Sure. You can use the DATEDIFF and GETDATE functions. See BOL.

 

[chrissparkle]

What is BOL?

 

[MDXer]

Books On Line, it is the SQL Server Help.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck