Fastpath Database Query

We’re using Fastpath and I’ve been requested to write an sql query displaying the number of chats an operator received on a given date. I can’t for the life of me figure out how to convert the MSSQL date to something intuitive (for example 2009-01-01). Any help anyone could give me would be greatly appreciated.


Sorry this is a bit over a year for an answer. But I just got started with fastpath last month.

Here is the SQL you need to convert the java long to a SQL DateTime

SELECT [sessionID]
      ,dateadd(ss, cast([jointime] as bigint)/1000,'19700101') AS joinTime
      ,dateadd(ss, cast([leftTime] as bigint)/1000,'19700101') AS leftTime
FROM [openfire].[dbo].[fpAgentSession]
order by joinTime asc