declare @endtime datetime
declare @begintime datetime
select @endtime=getdate(),@begintime=?????
print @endtime
print @begintime当前结果--------------------------06 11 2009 9:13AM想要的结果------------------------
06 11 2009 9:13AM
06 11 2009 9:00AM
declare @begintime datetime
select @endtime=getdate(),@begintime=?????
print @endtime
print @begintime当前结果--------------------------06 11 2009 9:13AM想要的结果------------------------
06 11 2009 9:13AM
06 11 2009 9:00AM
declare @begintime datetime
select @endtime=getdate(),@begintime=convert(varchar(15),@endtime,121)+'0'
print @endtime
print @begintime
SELECT CAST(CONVERT(VARCHAR(13),GETDATE(),120)+':00' AS DATETIME)
/*
-----------------------
2009-06-11 09:25:48.300
-----------------------
2009-06-11 09:00:00.000
*/
declare @begintime datetime
select @endtime=getdate(),@begintime=DATEADD(minute,DATEDIFF(minute,0,GETDATE())/60*60,0)
print @endtime
print @begintime
select getdate(),dateadd(mi,-datepart(mi,getdate()),getdate())
�ٽ�ȡ
select left(Convert(Varchar, GetDate(), 114), 2) Ϊ09Ϊ���㣬 ǰ���������� ������case���ȥ���select case when Left(left(Convert(Varchar, GetDate(), 114), 2), 1) = 0 then
right(left(Convert(Varchar, GetDate(), 114), 2), 1) else left(Convert(Varchar, GetDate(), 114), 2) end
declare @begintime datetime
select @endtime=getdate(),@begintime=convert(varchar(13),@endtime,120)+':00'
print @endtime
print @begintime
结果:
06 11 2009 9:46AM
06 11 2009 9:00AM
或者这样写也可以:declare @endtime datetime
declare @begintime datetime
select @endtime=getdate(),
@begintime=dateadd(mi,-datepart(mi,dateadd(ss,-datepart(ss,getdate()),getdate())),dateadd(ss,-datepart(ss,getdate()),getdate()))
print @endtime
print @begintime
10楼结果:06 11 2009 9:57AM
06 11 2009 9:00AM