Help with MS SQL DateTime Query

[Weltchy]

You bunch of bloody SQL amateurs. I put a question up about SQL no-one apart of Socky can answer it, someone puts a simple question up you all smarm over who can answer it.

Winging it, you're all bloody winging it.

Its Christmas. You know, the time to be jolly, give and receive presents, and of course provide dodgy, half cut solutions to questions about all and sundry!!!!

Seriously tho, wtf am I doing working at 7:15am just 3 days before xmas. If ever there was a working condition that says I'm not a bloody employee, this is it!!!!!

[expat]

You bunch of bloody SQL amateurs. I put a question up about SQL no-one apart of Socky can answer it, someone puts a simple question up you all smarm over who can answer it.

Winging it, you're all bloody winging it.

You put up a question about SQL Server, mate. I don't do that, I only do SQL (on real databases - Oracle and DB2). And I'm really pissed off with "SQL Server" polluting Google, and indeed Jobserve, for those of us who are looking for "SQL".

[wxman]

Firstly, thanks for all that answered my pleas for help on this SQL statement – all is working really well now.
Weltchy also asked why I was not formatting the date in application code?
I am actually using the SQL code in a stored procedure and then displaying the results in a net2 grid view. Figured that if I could get the stored proc to out put in the correct format that I wanted – then I could reference the proc in other area of my web page.

I did mention that I am not a programmer – so most likely this sis a more efficient way of doing this but right now the following works well for me.

SELECT TOP (5)
NickName AS Chaser,
Speed,
Direction,
Altitude,
CONVERT(char(5), (getutcdate()- gpsTime), 108) AS [Time ago],
CASE TrackerID
WHEN 'Tracker 1' THEN '1'
WHEN 'Tracker 2' THEN '2'
WHEN 'Tracker 3' THEN '3'
WHEN 'Tracker 4' THEN '4'
WHEN 'Tracker 5' THEN '5'
WHEN 'Tracker 6' THEN '6'
WHEN 'Tracker 7' THEN '7'
WHEN 'Tracker 8' THEN '8'
WHEN 'Tracker 9' THEN '9'
WHEN 'Tracker 10' THEN '10'
END AS [GPS]
FROM TrackerData
WHERE DATEDIFF(hour, gpsTime, GETUTCDATE()) < 12
ORDER BY gpsTime DESC