datetime(MSG.ZSENTAT, 'unixepoch', 'localtime')
,case
when MSG.Z30_USER1=31 then 'ME' || '->' || (select hex(CHT.ZACTIVEMEMBERIDS) from ZCHAT CHT where MSG.ZCHAT=CHT.Z_PK)
when MSG.Z30_USER1=30 then (select ZNAME from ZUSER USR where USR.Z_PK=MSG.ZUSER1) || '-> ME'
end
--USR.ZNAME
--,USR.ZNICKNAME
--,USR.ZPHONENUMBER
--,USR.ZSTATUSMESSAGE
--,MSG.ZSENTAT
,MSG.ZMESSAGE
from
ZMESSAGE MSG
left join ZUSER USR
on MSG.ZUSERID=USR.ZID
order by MSG.ZSENTAT asc
음... 어제 잠깐 봤는데, 보내는 사람 받는 사람부분이 좀 애매하게 되어있더라구효
애플 | 693명이 읽었어요. 3.135.184.21
