Hi all,
 
We need to get some informations from the extensionmobilitydynamic table requesting via axl executeSQLQuery.
 
Is there a way to cast the unix timestamp from the "DateTimeStamp" column to a "readable" datetime field, during the query?
 
At the moment the query looks like this
select enduser.userid, device.name from extensionmobilitydynamic,
device, enduser where extensionmobilitydynamic.fkdevice = device.pkid and 
extensionmobilitydynamic.fkenduser_lastlogin = enduser.pkid and
extensionmobilitydynamic.fkenduser IS NULL
now i need the lastLoggedOn users for the last week only.
 
I've tried the following queries, but nothing would work:
 
select cast(DateTimeStamp as DateTime)…

<!--[if !supportLists]-->

select …..where datetimestamp >= UNIX_TIMESTAMP(‘2012-10-20’)
select date(DateTimeStamp)…
 
CUCM Version: 8.6.1
 
kind regards
rené

<!---->

Hi David,
 
Thank you, thats exactly the query i'm looking for!