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