在一个月和一年之间使用 [英] use between for day month and year
问题描述
大家好,
请帮助我,
我在sqlsever中有三个不同的列表,如日,月和年。在这列中,值分别是整数。表结构如下:
日月年
3 10 2011
4 11 2011 >
5 12 2012
6 1 2012
i从我的申请日,月份和年份中通过下拉列表中的值。
现在我想从中检索数据。
假设我通过从值第3个月 - 10年 - 2011年估价第6个月 - 1年 - 2012年。如何在此之间使用以回溯记录。
提前致谢....
类似于 -
从表中选择* CAST(DATEPART(年,日)+'' - ''+ DATEPART(月,日) )+'' - ''+ DATEPART(日期,日期)作为日期时间)> @startDate AND CAST(DATEPART(年,日)+'' - ''+ DATEPART(月,日)+'' - ''+ DATEPART(日,日)作为日期时间)< @endDate
其中@startDate
和@endDate
是您的日期时间参数。
选择 * 来自 表格
其中
convert ( datetime ,( convert ( varchar ( 4 ),year)+ ' - ' + convert ( varchar ( 2 ),月)+ ' - ' + convert ( varchar ( 2 ) ,day)))在' 2011-10-03' 和 < span class =code-string>' 2012-01-06'
Happy编码!
:))你好<
SELECT Column_Name
FROM Table_Name
WHERE CONVERT ( VARCHAR ( 10 ),(CAST(YEAR_Column AS VARCHAR ( 4 ))+ ' - ' + CAST(Month_Column AS VARCHAR ( 4 ))+ ' - ' + CAST(Day_Column AS VARCHAR (< span class =code-digit> 4 ))), 112 )
BETWEEN CONVERT ( VARCHAR ( 10 ),From_Date, 112 ) AND CONVERT ( VARCHAR ( 10 ),To_Date, 112 )
GVPrabu
Hi all,
Please help me,
I have table in sqlsever with three different columns like day, month, and year. and in this columns values are interger respectively. table structure like as below:
Day Month Year
3 10 2011
4 11 2011
5 12 2012
6 1 2012
i passed the value from my application day, month and year from dropdown.
now i want to retrive data from this.
suppose i passed the From value day-3 month-10 year-2011 and To value day-6 month-1 year-2012. how to use between for this to retrive records.
Thanks in advance....解决方案Trymsomething like -
select * from table where CAST(DATEPART(year, DATE)+''-''+ DATEPART(month, DATE) +''-''+ DATEPART(day, DATE) AS DATETIME) > @startDate AND CAST(DATEPART(year, DATE)+''-''+ DATEPART(month, DATE) +''-''+ DATEPART(day, DATE) AS DATETIME)< @endDate
where@startDate
and@endDate
are your date time parameters.
select * from table where convert(datetime,(convert(varchar(4),year) + '-' + convert(varchar(2),month) + '-' + convert(varchar(2),day))) between '2011-10-03' and '2012-01-06'
Happy Coding!
:)
Hi ,
Try This Query..
SELECT Column_Name FROM Table_Name WHERE CONVERT(VARCHAR(10),(CAST(YEAR_Column AS VARCHAR(4))+'-'+CAST(Month_Column AS VARCHAR(4))+'-'+CAST(Day_Column AS VARCHAR(4))), 112) BETWEEN CONVERT(VARCHAR(10),From_Date, 112) AND CONVERT(VARCHAR(10),To_Date, 112)
GVPrabu
这篇关于在一个月和一年之间使用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!