<p>您可以使用<a href="http://msdn.microsoft.com/en-us/library/ms188043.aspx" rel="nofollow">STUFF function</a>:</p>
<pre><code>DECLARE @MyTable TABLE([Date] VARCHAR(20));
INSERT @MyTable ([Date])
VALUES ('20130622133644403');
SELECT y.*,
CONVERT(DATE,y.Date_AsDateTime) AS OnlyDate,
CONVERT(TIME(0),y.Date_AsDateTime) AS OnlyTime
FROM(
SELECT x.[Date] AS Date_AsVarChar, CONVERT(DATETIME, STUFF(STUFF(STUFF(STUFF(x.[Date],9,0,' '),12,0,':'),15,0,':'),18,0,'.')) AS Date_AsDateTime
FROM @MyTable x
) y;
</code></pre>
<p>结果:</p>
<pre><code>Date_AsVarChar Date_AsDateTime OnlyDate OnlyTime
-------------------- ----------------------- ---------- --------
20130622133644403 2013-06-22 13:36:44.403 2013-06-22 13:36:44
</code></pre>
<p><strong>解决方案:</strong></p>
<pre><code>SELECT
CONVERT(DATE,y.Date_AsDateTime) AS OnlyDate,
CONVERT(TIME(0),y.Date_AsDateTime) AS OnlyTime
FROM(
SELECT [Object], MsgId, Parms,
CONVERT(DATETIME, STUFF(STUFF(STUFF(STUFF(x.[Date],9,0,' '),12,0,':'),15,0,':'),18,0,'.')) AS Date_AsDateTime
FROM JnlDataSection
) A
WHERE MsgID = '325'
-- SUBSTRING(Parms,1,6) = 'V40449' is not SARG-able
AND Parms LIKE 'V40449%'
ORDER BY DATE DESC;
</code></pre>