锘??xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>&#26085;&#38889;&#19968;&#21306;&#20108;&#21306;&#22312;&#32447;&#25773;&#25918;&#44;&#22269;&#20135;&#20262;&#19968;&#21306;&#20108;&#21306;&#19977;&#21306;&#44;&#38738;&#38738;&#33609;&#19968;&#21306;&#20108;&#21306;</title><link>http://www.aygfsteel.com/Yanjiang/</link><description /><language>zh-cn</language><lastBuildDate>Mon, 04 Aug 2025 20:03:58 GMT</lastBuildDate><pubDate>Mon, 04 Aug 2025 20:03:58 GMT</pubDate><ttl>60</ttl><item><title>Can I make SQL Server format dates and times for me?</title><link>http://www.aygfsteel.com/Yanjiang/archive/2006/10/18/76020.html</link><dc:creator>YanJiang</dc:creator><author>YanJiang</author><pubDate>Wed, 18 Oct 2006 12:16:00 GMT</pubDate><guid>http://www.aygfsteel.com/Yanjiang/archive/2006/10/18/76020.html</guid><wfw:comment>http://www.aygfsteel.com/Yanjiang/comments/76020.html</wfw:comment><comments>http://www.aygfsteel.com/Yanjiang/archive/2006/10/18/76020.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/Yanjiang/comments/commentRss/76020.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/Yanjiang/services/trackbacks/76020.html</trackback:ping><description><![CDATA[CREATE FUNCTION dbo.FormatDateTime聽<br />(聽<br />聽 聽 @dt DATETIME,聽<br />聽 聽 @format VARCHAR(16)聽<br />)聽<br />RETURNS VARCHAR(64)聽<br />AS聽<br />BEGIN聽<br />聽 聽 DECLARE @dtVC VARCHAR(64)聽<br />聽 聽 SELECT @dtVC = CASE @format聽<br />聽聽聽 WHEN 'LONGDATE' THEN聽<br />聽聽聽聽聽聽聽 DATENAME(dw, @dt)聽<br />聽 聽 聽 聽 + ',' + SPACE(1) + DATENAME(m, @dt)聽<br />聽 聽 聽 聽 + SPACE(1) + CAST(DAY(@dt) AS VARCHAR(2))聽<br />聽 聽 聽 聽 + ',' + SPACE(1) + CAST(YEAR(@dt) AS CHAR(4))聽<br />聽聽聽 WHEN 'LONGDATEANDTIME' THEN聽<br />聽聽聽聽聽聽聽 DATENAME(dw, @dt)聽<br />聽 聽 聽 聽 + ',' + SPACE(1) + DATENAME(m, @dt)聽<br />聽 聽 聽 聽 + SPACE(1) + CAST(DAY(@dt) AS VARCHAR(2))聽<br />聽 聽 聽 聽 + ',' + SPACE(1) + CAST(YEAR(@dt) AS CHAR(4))聽<br />聽 聽 聽 聽 + SPACE(1) + RIGHT(CONVERT(CHAR(20),聽<br />聽 聽 聽 聽 @dt - CONVERT(DATETIME, CONVERT(CHAR(8),聽<br />聽 聽 聽 聽 @dt, 112)), 22), 11)聽<br />聽聽聽 WHEN 'SHORTDATE' THEN聽<br />聽聽聽聽聽聽聽 LEFT(CONVERT(CHAR(19), @dt, 0), 11)聽<br />聽聽聽 WHEN 'SHORTDATEANDTIME' THEN聽<br />聽聽聽聽聽聽聽 REPLACE(REPLACE(CONVERT(CHAR(19), @dt, 0),'AM', ' AM'), 'PM', ' PM')聽<br />聽聽聽 WHEN 'UNIXTIMESTAMP' THEN聽<br />聽聽聽聽聽聽聽 CAST(DATEDIFF(SECOND, '19700101', @dt)聽AS VARCHAR(64))聽<br />聽聽聽 WHEN 'YYYYMMDD' THEN聽<br />聽聽聽聽聽聽聽 CONVERT(CHAR(8), @dt, 112)聽<br />聽聽聽 WHEN 'YYYY-MM-DD' THEN聽<br />聽聽聽聽聽聽聽 CONVERT(CHAR(10), @dt, 23)聽<br />聽聽聽 WHEN 'YYMMDD' THEN聽<br />聽聽聽聽聽聽聽 CONVERT(VARCHAR(8), @dt, 12)聽<br />聽聽聽 WHEN 'YY-MM-DD' THEN聽<br />聽聽聽聽聽聽聽 STUFF(STUFF(CONVERT(VARCHAR(8), @dt, 12),聽5, 0, '-'), 3, 0, '-')聽<br />聽聽聽 WHEN 'MMDDYY' THEN聽<br />聽聽聽聽聽聽聽 REPLACE(CONVERT(CHAR(8), @dt, 10), '-', SPACE(0))聽<br />聽聽聽 WHEN 'MM-DD-YY' THEN聽<br />聽聽聽聽聽聽聽 CONVERT(CHAR(8), @dt, 10)聽<br />聽聽聽 WHEN 'MM/DD/YY' THEN聽<br />聽聽聽聽聽聽聽 CONVERT(CHAR(8), @dt, 1)聽<br />聽聽聽 WHEN 'MM/DD/YYYY' THEN聽<br />聽聽聽聽聽聽聽 CONVERT(CHAR(10), @dt, 101)聽<br />聽聽聽 WHEN 'DDMMYY' THEN聽<br />聽聽聽聽聽聽聽 REPLACE(CONVERT(CHAR(8), @dt, 3), '/', SPACE(0))聽<br />聽聽聽 WHEN 'DD-MM-YY' THEN聽<br />聽聽聽聽聽聽聽 REPLACE(CONVERT(CHAR(8), @dt, 3), '/', '-')聽<br />聽聽聽 WHEN 'DD/MM/YY' THEN聽<br />聽聽聽聽聽聽聽 CONVERT(CHAR(8), @dt, 3)聽<br />聽聽聽 WHEN 'DD/MM/YYYY' THEN聽<br />聽聽聽聽聽聽聽 CONVERT(CHAR(10), @dt, 103)聽<br />聽聽聽 WHEN 'HH:MM:SS 24' THEN聽<br />聽聽聽聽聽聽聽 CONVERT(CHAR(8), @dt, 8)聽<br />聽聽聽 WHEN 'HH:MM 24' THEN聽<br />聽聽聽聽聽聽聽 LEFT(CONVERT(VARCHAR(8), @dt, 8), 5)聽<br />聽聽聽 WHEN 'HH:MM:SS 12' THEN聽<br />聽聽聽聽聽聽聽 LTRIM(RIGHT(CONVERT(VARCHAR(20), @dt, 22), 11))聽<br />聽聽聽 WHEN 'HH:MM 12' THEN聽<br />聽聽聽聽聽聽聽 LTRIM(SUBSTRING(CONVERT(聽<br />聽 聽 聽 聽 VARCHAR(20), @dt, 22), 10, 5)聽<br />聽 聽 聽 聽 + RIGHT(CONVERT(VARCHAR(20), @dt, 22), 3))聽<br />聽聽聽 ELSE聽<br />聽聽聽聽聽聽聽 'Invalid format specified'聽<br />聽聽聽 END聽<br />聽 聽 RETURN @dtVC聽<br />END聽<br />GO<br />====================================================================================<br />====================================================================================<br />DECLARE @now DATETIME聽<br />SET @now = GETDATE()聽<br />聽<br />PRINT dbo.FormatDateTime(@now, 'LONGDATE')聽<br />PRINT dbo.FormatDateTime(@now, 'LONGDATEANDTIME')聽<br />PRINT dbo.FormatDateTime(@now, 'SHORTDATE')聽<br />PRINT dbo.FormatDateTime(@now, 'SHORTDATEANDTIME')聽<br />PRINT dbo.FormatDateTime(@now, 'UNIXTIMESTAMP')聽<br />PRINT dbo.FormatDateTime(@now, 'YYYYMMDD')聽<br />PRINT dbo.FormatDateTime(@now, 'YYYY-MM-DD')聽<br />PRINT dbo.FormatDateTime(@now, 'YYMMDD')聽<br />PRINT dbo.FormatDateTime(@now, 'YY-MM-DD')聽<br />PRINT dbo.FormatDateTime(@now, 'MMDDYY')聽<br />PRINT dbo.FormatDateTime(@now, 'MM-DD-YY')聽<br />PRINT dbo.FormatDateTime(@now, 'MM/DD/YY')聽<br />PRINT dbo.FormatDateTime(@now, 'MM/DD/YYYY')聽<br />PRINT dbo.FormatDateTime(@now, 'DDMMYY')聽<br />PRINT dbo.FormatDateTime(@now, 'DD-MM-YY')聽<br />PRINT dbo.FormatDateTime(@now, 'DD/MM/YY')聽<br />PRINT dbo.FormatDateTime(@now, 'DD/MM/YYYY')聽<br />PRINT dbo.FormatDateTime(@now, 'HH:MM:SS 24')聽<br />PRINT dbo.FormatDateTime(@now, 'HH:MM 24')聽<br />PRINT dbo.FormatDateTime(@now, 'HH:MM:SS 12')聽<br />PRINT dbo.FormatDateTime(@now, 'HH:MM 12')聽<br />PRINT dbo.FormatDateTime(@now, 'goofy')<br /><br />(((*****)))<br /><a >http://sqlserver2000.databases.aspfaq.com/can-i-make-sql-server-format-dates-and-times-for-me.html</a><br /><br /><br /><br /><br /><img src ="http://www.aygfsteel.com/Yanjiang/aggbug/76020.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/Yanjiang/" target="_blank">YanJiang</a> 2006-10-18 20:16 <a href="http://www.aygfsteel.com/Yanjiang/archive/2006/10/18/76020.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>鏈夌偣鎰忔�?/title><link>http://www.aygfsteel.com/Yanjiang/archive/2005/12/21/24966.html</link><dc:creator>YanJiang</dc:creator><author>YanJiang</author><pubDate>Wed, 21 Dec 2005 08:45:00 GMT</pubDate><guid>http://www.aygfsteel.com/Yanjiang/archive/2005/12/21/24966.html</guid><wfw:comment>http://www.aygfsteel.com/Yanjiang/comments/24966.html</wfw:comment><comments>http://www.aygfsteel.com/Yanjiang/archive/2005/12/21/24966.html#Feedback</comments><slash:comments>2</slash:comments><wfw:commentRss>http://www.aygfsteel.com/Yanjiang/comments/commentRss/24966.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/Yanjiang/services/trackbacks/24966.html</trackback:ping><description><![CDATA[瀵逛竴鎵圭紪鍙蜂負(fù)1~100鍏ㄩ儴寮�鍏蟲湞涓婏紙寮�錛夌殑鐏繘琛屼互涓嬫搷浣滐細(xì)鍑℃槸1鐨勫�嶆暟鍙嶆柟鍚戞嫧涓�嬈″紑鍏籌紱2鐨勫�嶆暟鍙嶆柟鍚戝張鎷ㄤ竴嬈″紑鍏籌紱3鐨勫�嶆暟鍙嶆柟鍚戝張鎷ㄤ竴嬈″紑鍏?........<BR>闂細(xì)鏈�鍚庝負(fù)鍏崇唲鐘舵�佺殑鐏殑緙栧彿銆?img src ="http://www.aygfsteel.com/Yanjiang/aggbug/24966.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/Yanjiang/" target="_blank">YanJiang</a> 2005-12-21 16:45 <a href="http://www.aygfsteel.com/Yanjiang/archive/2005/12/21/24966.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item></channel></rss>     <footer>
<div class="friendship-link">
<a href="http://www.aygfsteel.com/" title="&#29408;&#29408;&#20037;&#20037;&#20122;&#27954;&#27431;&#32654;&#19987;&#21306;&#95;&#20013;&#25991;&#23383;&#24149;&#20122;&#27954;&#32508;&#21512;&#20037;&#20037;&#50;&#48;&#50;&#95;&#22269;&#20135;&#31934;&#21697;&#20122;&#27954;&#31532;&#20116;&#21306;&#22312;&#32447;&#95;&#26085;&#26412;&#20813;&#36153;&#32593;&#31449;&#35270;&#39057;">&#29408;&#29408;&#20037;&#20037;&#20122;&#27954;&#27431;&#32654;&#19987;&#21306;&#95;&#20013;&#25991;&#23383;&#24149;&#20122;&#27954;&#32508;&#21512;&#20037;&#20037;&#50;&#48;&#50;&#95;&#22269;&#20135;&#31934;&#21697;&#20122;&#27954;&#31532;&#20116;&#21306;&#22312;&#32447;&#95;&#26085;&#26412;&#20813;&#36153;&#32593;&#31449;&#35270;&#39057;</a>

</div>

</footer>


主站蜘蛛池模板：
<a href="http://" target="_blank">常山县</a>|
<a href="http://" target="_blank">顺义区</a>|
<a href="http://" target="_blank">浏阳市</a>|
<a href="http://" target="_blank">西林县</a>|
<a href="http://" target="_blank">图们市</a>|
<a href="http://" target="_blank">安陆市</a>|
<a href="http://" target="_blank">梅河口市</a>|
<a href="http://" target="_blank">黄龙县</a>|
<a href="http://" target="_blank">腾冲县</a>|
<a href="http://" target="_blank">宜昌市</a>|
<a href="http://" target="_blank">南涧</a>|
<a href="http://" target="_blank">垫江县</a>|
<a href="http://" target="_blank">乐平市</a>|
<a href="http://" target="_blank">龙州县</a>|
<a href="http://" target="_blank">昌乐县</a>|
<a href="http://" target="_blank">晴隆县</a>|
<a href="http://" target="_blank">隆昌县</a>|
<a href="http://" target="_blank">丰镇市</a>|
<a href="http://" target="_blank">大安市</a>|
<a href="http://" target="_blank">寿宁县</a>|
<a href="http://" target="_blank">贵港市</a>|
<a href="http://" target="_blank">昭平县</a>|
<a href="http://" target="_blank">弥勒县</a>|
<a href="http://" target="_blank">日喀则市</a>|
<a href="http://" target="_blank">盈江县</a>|
<a href="http://" target="_blank">江北区</a>|
<a href="http://" target="_blank">治县。</a>|
<a href="http://" target="_blank">淄博市</a>|
<a href="http://" target="_blank">马山县</a>|
<a href="http://" target="_blank">大余县</a>|
<a href="http://" target="_blank">巴彦淖尔市</a>|
<a href="http://" target="_blank">萨嘎县</a>|
<a href="http://" target="_blank">荔波县</a>|
<a href="http://" target="_blank">武定县</a>|
<a href="http://" target="_blank">敖汉旗</a>|
<a href="http://" target="_blank">耒阳市</a>|
<a href="http://" target="_blank">庄浪县</a>|
<a href="http://" target="_blank">抚顺市</a>|
<a href="http://" target="_blank">大石桥市</a>|
<a href="http://" target="_blank">神农架林区</a>|
<a href="http://" target="_blank">深州市</a>|
<script>
(function(){
    var bp = document.createElement('script');
    var curProtocol = window.location.protocol.split(':')[0];
    if (curProtocol === 'https') {
        bp.src = 'https://zz.bdstatic.com/linksubmit/push.js';
    }
    else {
        bp.src = 'http://push.zhanzhang.baidu.com/push.js';
    }
    var s = document.getElementsByTagName("script")[0];
    s.parentNode.insertBefore(bp, s);
})();
</script>
</body>