大家好, 请帮助我, 我在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' 和 ' 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 ( 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
更多推荐
在一个月和一年之间使用
发布评论