时期格式使用
在 sqlserver 中,有时要用到
yyyy-mm 这种格式
在区间比较时是很有用的...
CREATE function get_Date_Yy_Mm (@time datetime )
returns varchar(7)
as
begin
declare @str varchar(7)
set @str=''
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
set @str=convert(varchar(7),@time,126)
![](/Images/OutliningIndicators/None.gif)
return @str
end
![](/Images/OutliningIndicators/None.gif)
sql2000 帮助中有好多 convert 的对时间的格式方式....
yyyy-mm 这种格式
在区间比较时是很有用的...
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)