什么是{ts'2013-04-02 00:00:00'}? [英] What is {ts '2013-04-02 00:00:00'}?
本文介绍了什么是{ts'2013-04-02 00:00:00'}?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
当我分析运行的T-SQL时,我在where子句中找到了{ts' 2013-04-02 00:00:00'}的查询。我对此非常好奇并试图找到消息来源。它由CrystalReport报告执行。
这里是查询。
SELECT *
FROM [表] B
WHERE CONVERT ( VARCHAR ,[ AddedDateTime], 111 )
BETWEEN CONVERT ( VARCHAR ,{ts' 2013-03-31 00:00:00'}, 111 )
AND CONVERT ( VARCHAR ,{ts' 2013-04-02 00:00:00'}, 111 )
解决方案
这是一个ODBC文字转义序列。
阅读日期,时间,和时间戳转义序列 [ ^ ]
MSDN参考。 。参见ODBC部分 [ ^
when i analyzing running T-SQL I found a query that have {ts '2013-04-02 00:00:00'} in where clause. i was so curious about this and tried to find the source. It was executed by a CrystalReport Report.
here is the query.
SELECT *
FROM [Table] B
WHERE CONVERT(VARCHAR, [AddedDateTime], 111)
BETWEEN CONVERT(VARCHAR, {ts '2013-03-31 00:00:00'}, 111)
AND CONVERT(VARCHAR, {ts '2013-04-02 00:00:00'}, 111)
解决方案
It's an ODBC literal escape sequence.
read Date, Time, and Timestamp Escape Sequences[^]
MSDN Reference.. see ODBC section[^]
这篇关于什么是{ts'2013-04-02 00:00:00'}?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文