sql server相关的querry [英] sql server related querry
问题描述
嗨我正在使用这个奇怪的
从RechargeReport中选择*,其中Date =''convert(Varchar,Date,103 )''01 / 04/2013''和'24 / 04/2013之间''''
并得到了错误
消息102,等级15,状态1,行1
''01'附近的语法不正确。
谢谢和关注
Hemant Mishra
< pre lang =SQL> 选择 *
来自 RechargeReport
其中 日期 ' 2013/04/01' 和 ' 2013/04/24'
快乐编码!
:)
[Date]
字段是日期时间类型,则不需要将其转换为字符串(varchar)。
< pre lang =SQL> SELECT *
FROM RechargeReport
WHERE [日期] BETWEEN ' 01/04/2013' AND ' 24/04/2013'
如果你想转换 [Date]
string(varchar),你需要这样做:
SELECT *
FROM RechargeReport
WHERE CONVERT ( VARCHAR ( 10 ),[日期], 103 ) BETWEEN ' 01/04/2013' AND ' 24/04/2013'
选择 *
来自 RechargeReport
其中 日期> = 2013/04/01 和日期39< = 2013年4月24日
hi i`m using this queery
select * from RechargeReport where Date=''convert(Varchar,Date,103) between ''01/04/2013'' and ''24/04/2013''''
and got a error
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ''01''.
Thanks & regard
Hemant Mishra
select * from RechargeReport where Date between '2013/04/01' and '2013/04/24'
Happy Coding!
:)
If[Date]
field is a datetime type, you don''t need to convert it as a string (varchar).
SELECT * FROM RechargeReport WHERE [Date] BETWEEN '01/04/2013' AND '24/04/2013'
If you want to convert[Date]
string (varchar), you need to do that as follow:
SELECT * FROM RechargeReport WHERE CONVERT(VARCHAR(10),[Date],103) BETWEEN '01/04/2013' AND '24/04/2013'
In case of converting error, see this: SET DATEFORMAT[^]
select * from RechargeReport where Date >= 2013/04/01 and Date39 <=2013/04/24
这篇关于sql server相关的querry的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!