<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[chaowon的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/chaowon</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; chaowon]]></copyright><item><title><![CDATA[SQLserver中用convert函数转换日期格式]]></title><link>https://blog.youkuaiyun.com/chaowon/article/details/56306767</link><guid>https://blog.youkuaiyun.com/chaowon/article/details/56306767</guid><author>chaowon</author><pubDate>Tue, 21 Feb 2017 21:30:41 +0800</pubDate><description><![CDATA[SQLserver中用convert函数转换日期格式2008-01-15 15:51




SQLserver中用convert函数转换日期格式

SQL Server中文版的默认的日期字段datetime格式是yyyy-mm-dd Thh:mm:ss.mmm

例如:

select getdate()

2004-09-12 11:06:08.177

整理了一]]></description><category></category></item><item><title><![CDATA[SQL SERVER 转换大小写]]></title><link>https://blog.youkuaiyun.com/chaowon/article/details/56304675</link><guid>https://blog.youkuaiyun.com/chaowon/article/details/56304675</guid><author>chaowon</author><pubDate>Tue, 21 Feb 2017 21:18:15 +0800</pubDate><description><![CDATA[select lower(UPPER(npdunittype)) from JRtePipeRun]]></description><category></category></item><item><title><![CDATA[SQ, SERVER 添加默认约束]]></title><link>https://blog.youkuaiyun.com/chaowon/article/details/56024746</link><guid>https://blog.youkuaiyun.com/chaowon/article/details/56024746</guid><author>chaowon</author><pubDate>Mon, 20 Feb 2017 20:27:29 +0800</pubDate><description><![CDATA[ALTER TABLE [表名] add CONSTRAINT [约束名]  DEFAULT getdate() FOR [列名]]]></description><category></category></item></channel></rss>