Viewing 2 posts - 1 through 3 (of 3 total)
What did I post wrong? I read your best practices Etiquette.
November 12, 2012 at 10:47 am
#1558243
This is an SQL 2000 database my query is:
SELECT EXTENSION, timestamp, CONVERT(VARCHAR,Duration / 60) + ':' + RIGHT('00' + CONVERT(VARCHAR,duration % 60),2) as DURATION
FROM CDR
WHERE (TIMESTAMP BETWEEN CONVERT(DATETIME, '2012-10-01...
November 12, 2012 at 9:50 am
#1558218