mercredi 29 avril 2015

How break a time range between n numbers of equal intervals?

TimeMin: 2015-04-29 10:57:56.623

TimeMax: 2015-04-29 11:04:35.133

I am trying to write a select query to break this into n equal intervals

This is my attempt:

declare @Min int
select @Min  = min(DATEDIFF(ss,'1970-01-01', biddate)) from tbl_bids
declare @Max int
select @Max  = max(DATEDIFF(ss,'1970-01-01', biddate)) from tbl_bids

declare @NumParts int 
select @NumParts =COUNT(*) from tbl_bids

select ((DATEDIFF(ss,'1970-01-01', biddate) * (@Max - @Min) / @NumParts) + 1) - ((@Max - @Min) / @NumParts), 
(DATEDIFF(ss,'1970-01-01', biddate) * (@Max - @Min) / @NumParts) + 1
from tbl_bids 
where DATEDIFF(ss,'1970-01-01', biddate)<= @NumParts

But it returns 0 rows.

EXAMPLE:

Min: 2015-04-29 10:50:00

Max: 2015-04-29 11:00:00

if NumParts =5 (breaking into 5 equal intervals) output should be

2015-04-29 10:52:00
2015-04-29 10:54:00
2015-04-29 10:56:00
2015-04-29 10:58:00
2015-04-29 11:00:00

Aucun commentaire:

Enregistrer un commentaire