SELECT
CONVERT(datetime, SWITCHOFFSET(CONVERT(datetimeoffset, TimeStamp), DATENAME(TzOffset, SYSDATETIMEOFFSET()))) AS ColumnInLocalTime, *
FROM
[QHistorianData].[dbo].[EXAOPCCSProcessAlarm] ORDER by TimeStamp desc
nvarchar
data type, rather than varchar.
dsdsHOW ARA WORKS
"A4A1","0x0004FF0B","1396594144170","1396594144880.26","10TEST201AN TESTING 1 2 3 ALM","0","1201","Process","10TEST201AN.ALM","FCS0101","","","10TEST201AN","","High","","","","","","","Disable","1"
"A4A1","0x0005099B","1396594147170","1396594147879.43","10TEST201AN TESTING 1 2 3 NR","0","1206","Process","10TEST201AN.ALM","FCS0101","","","10TEST201AN","","Low","","","","","","","Disable","1"
"A6","0x00045754","1396593346928.62","33","TESTUSER","HIS0164","","{5ED17248-68A9-485C-A42F-9DA1E046E6FA}","","","","","",""
"A6","0x00045804","1396593346937.62","31","TESTUSER","HIS0164","10TEST201AN.ALM;;","{00000000-0000-0000-0000-000000000000}","1396593049170","{5ED17248-68A9-485C-A42F-9DA1E046E6FA}","257","1","",""
"A4A1","0x00063145","1396594421170","1396594421880.1","10TEST201AN TESTING 1 2 3 NR","0","1206","Process","10TEST201AN.ALM","FCS0101","","","10TEST201AN","","Low","","","","","","","Enable","1"
"A4A1","0x00063C44","1396594488170","1396594488880.93","10TEST201AN TESTING 1 2 3 ALM","4","1201","Process","10TEST201AN.ALM","FCS0101","","","10TEST201AN","","High","","","","","","","Enable","1"
Exaquantum SER (Sequence of Events Recorder)