SELECT TOP 1000 [trxNo]
,[trxCode]
,[timeEntry]
,[terminalId]
,[kode]
,[traceNo]
,[accountNo]
,[responseCode]
,[lineToPrint]
,[message]
FROM [Retcom].[dbo].[transactions] where substring(convert(varchar, timeEntry, 120),1, 4) = '2015'
untuk lebih lengkap dengan tgl dan jam nya
[RetcomBSM].[dbo].[transactions] where substring(convert(varchar, timeEntry, 120),1, 19) = '2012-02-28 00:00:09'
Perhatian: Yuk Baca Artikel bagus di Nurul Musthofa
No comments:
Post a comment