case 日期when 范围_查询范围日期(各种方法)

东莞

-

♂

-

书桓

制作

create

function

getdatetime

(

@begin_date

datetime

,

@end_date

datetime

)

returns

@t

table

(

date

datetime

)

as

begin

with

feifei

as

(

Select

@begin_date

AS

date

union

all

select

date

+

1

from

feifei

where

date

+

1

<=

@end_date

)

insert

into

@t

select

*

from

feifei

option

(

maxrecursion

0

);

return

end

go

select

*

from

dbo

.

getdatetime

(

'1970-01-01'

,

'2000-12-31'

)

中山♂拾荒

制作

declare

@

开始日期

datetime

declare

@

结束日期

datetime

declare

@t

table

(

dt

datetime

)

select

@

开始日期

=

'1970-01-01'

select

@

结束日期

=

'2000-12-31'

while

@

开始日期

<=

@

结束日期

begin

insert

@t

select

@

开始日期

set

@

开始日期

=

@

开始日期

+

1

end

select

convert

(

char

(

10

),

dt

,

120

)

AS

日期

from

@t

中山♂竹子

制作

CREATE

table

#DATE

(

DATE

datetime

)

declare

@date

as

datetime

set

@date

=

'1970-01-01'

while

@date

<=

'2000-12-31'

begin

insert

into

#DATE

select

@date

set

@date

=

dateadd

(

day

,

1

,

@date

)

end

select

*

from

#DATE