Posts in 2017

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair

Q&A for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT 'MIN',
MIN(DATEDIFF(DAY, CreationDate, GETDATE())) as Acct_Age_Days
FROM Users
UNION
SELECT 'MAX',
MAX(DATEDIFF(DAY, CreationDate, GETDATE()))
FROM Users
UNION
SELECT 'MEAN',
AVG(CAST(DATEDIFF(DAY, CreationDate, GETDATE()) AS BIGINT))
FROM Users
UNION
SELECT 'SD',
STDEV(DATEDIFF(DAY, CreationDate, GETDATE()))
FROM Users

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results