转换(varchar,convert(日期,[日期],103),101) [英] Convert(varchar, convert(date, [date], 103), 101)
问题描述
当我使用convert(varchar,convert(date,[Date],103),101)如果数据在特定日期不可用,则此查询将获取下一个日期数据。
我尝试过:
convert(varchar,convert(date,[Date],103),101)
when i use convert(varchar,convert(date, [Date], 103),101) if data is not available on particular date this query is fetching next date data .
What I have tried:
convert(varchar,convert(date, [Date], 103),101)
推荐答案
当我使用 convert(varchar,convert(date,[Date],103),101)
如果数据在特定日期不可用,则此查询将获取下一个日期数据。
when i use convert(varchar,convert(date, [Date], 103),101)
if data is not available on particular date this query is fetching next date data .
上述声明不真实!
Above statement is untrue!
SELECT convert(varchar,convert(date, null, 103),101) AS myDate
--returns: NULL
SELECT convert(varchar,convert(date, '', 103),101) AS myDate
--returns: 1900-01-01
有关详细信息,请参阅: CAST和CONVERT(Transact-SQL) [ ^ ]
For further details, please see: CAST and CONVERT (Transact-SQL)[^]
当仅表示日期或仅时间组件的字符数据被强制转换为datetime或smalldatetime数据类型时,未指定的时间组件设置为00:00:00.000,并且未指定的日期组件设置为 1900-01-01
。
When character data that represents only date or only time components is cast to the datetime or smalldatetime data types, the unspecified time component is set to 00:00:00.000, and the unspecified date component is set to 1900-01-01
.
这篇关于转换(varchar,convert(日期,[日期],103),101)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!