我有这个查询,并在表/列ttransactionlog_1/发生时间,它返回的时间值与一个。000在最后,有人能告诉我如何从每一行删除?下面是输出文件中的一行,显示时间
末尾的。0000,112213,2021-03-11 14:00:00.000,Santiago,Melody,AdminClock.
下面是查询:
sqlcmd -S clockpunch -d test -U xxx -P xxxxx -Q "Select Distinct TTransactionLog_1.DecisionTimeInterval, TTransactionLog_1.UserID, TTransactionLog_1.OccurDateTime, TTransactionLog_1.lastname, TTransactionLog_1.firstname, TSystemLog1.Name
From TTransactionLog_1 Inner join TSystemLog1 On TTransactionLog_1.NodeID=TSystemLog1.NodeID where TSystemLog1.NodeID = 3 and TTransactionLog_1.OccurDateTime > = dateadd(hh, -1, getdate())
" -s "," -h-1 -W -o "C:ATRadminreport.csv"
提前感谢!
在OccurDateTime
值上使用Convert
对您有用吗?
declare @OccurDateTime datetime='20210311 14:00:00.000'
select Convert(varchar(19),@OccurDateTime,121)