擅长:python、mysql、java
<p>您可能需要研究convert()函数:</p>
<pre><code> select convert(date, getdate()) as [Date], convert(varchar(8), convert(time, getdate())) as [Time]
</code></pre>
<p>给予</p>
<pre><code> Date Time
---------- --------
2013-07-16 15:05:43
</code></pre>
<p>将这些内容包装在原始SQL中,会给您带来公认的非常难看的结果:</p>
<pre><code>SELECT convert(date,
DATEADD(HOUR,-4,CONVERT(DATETIME,LEFT([Date],8)+' '+
SUBSTRING([Date],10,2)+':'+
SUBSTRING([Date],12,2)+':'+
SUBSTRING([Date],14,2)+'.'+
SUBSTRING([Date],15,3)))) [Date],
convert(varchar(8), convert(time,
DATEADD(HOUR,-4,CONVERT(DATETIME,LEFT([Date],8)+' '+
SUBSTRING([Date],10,2)+':'+
SUBSTRING([Date],12,2)+':'+
SUBSTRING([Date],14,2)+'.'+
SUBSTRING([Date],15,3))))) [Time],
[Object] AS [Dataset],
SUBSTRING(Parms,1,6) AS [Media]
FROM (Select CONVERT(VARCHAR(18),[Date]) [Date],
[Object],
MsgId,
Parms
FROM JnlDataSection) A
Where MsgID = '325' AND
SUBSTRING(Parms,1,6) = 'V40449'
Order By Date DESC;
</code></pre>
<p>您可能希望将其中的一部分移到视图中,以减少复杂性。</p>