如何用C#和SQL获得当前月的第一天和最后一天
Posted on 2008-04-02 18:35 停留的风 阅读(233) 评论(0) 编辑 收藏 网摘 所属分类: 工作经历, Asp.net Body:62.5,BeforeCate:0,0,Total:78.125
在日常开发中,经常需要我们对时间判断是否是在当前月内
C#
C#
int
year
=
DateTime.Now.Year;
int month = DateTime.Now.Month;
DateTime firstDayOfThisMonth = new DateTime(year, month, 1 );
DateTime lastDayOfThisMonth = new DateTime(year, month, DateTime.DaysInMonth(year, month));
SQL
int month = DateTime.Now.Month;
DateTime firstDayOfThisMonth = new DateTime(year, month, 1 );
DateTime lastDayOfThisMonth = new DateTime(year, month, DateTime.DaysInMonth(year, month));
DECLARE
@NOW
DATETIME
DECLARE @FistDayOfThisMonth DATETIME
DECLARE @LastDayOfThisMonth DATETIME
SET @NOW = GETDATE ()
SET @FistDayOfThisMonth = @NOW - DAY ( @NOW ) + 1
SET @LastDayOfThisMonth = DATEADD ( MONTH , 1 , @NOW - DAY ( @NOW ) + 1 ) - 1
SELECT @FistDayOfThisMonth
SELECT @LastDayOfThisMonth
DECLARE @FistDayOfThisMonth DATETIME
DECLARE @LastDayOfThisMonth DATETIME
SET @NOW = GETDATE ()
SET @FistDayOfThisMonth = @NOW - DAY ( @NOW ) + 1
SET @LastDayOfThisMonth = DATEADD ( MONTH , 1 , @NOW - DAY ( @NOW ) + 1 ) - 1
SELECT @FistDayOfThisMonth
SELECT @LastDayOfThisMonth