CodingForums.com - View Single Post - How can i fetch all the values in a minute from a table ?

guelphdad · 10-01-2012, 12:18 PM

as suggested in another forum you have posted this same question in, create a calendar table with every single minute of every day created and then use a LEFT JOIN to join your other table to the calendar table.

10-01-2012, 12:18 PM	PM User \| #4
guelphdad Super Moderator Join Date: Mar 2006 Location: St. Catharines, Ontario Canada Posts: 2,629 Thanks: 4 Thanked 147 Times in 138 Posts	as suggested in another forum you have posted this same question in, create a calendar table with every single minute of every day created and then use a LEFT JOIN to join your other table to the calendar table.