title: What is {ts '2013-04-02 00:00:00'}?
body: <p>when i analyzing running T-SQL I found a query that have <strong>{ts</strong> '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. </p>
  
  <p>here is the query.</p>
  
  <pre><code>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)
  </code></pre>
  
  <p>Can anyone tel me what is it and where we can use it?</p>