chrissparkle
Programmer
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?
Is this possible from within the select statement?