We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
DELIMITER | CREATE PROCEDURE fill_calendar(start_date DATE, end_date DATE) BEGIN DECLARE crt_date DATE; DECLARE Yr INT; DECLARE Mo INT; SET crt_date = start_date; SET Yr= Year(start_date); SET Mo= Month(start_date); WHILE crt_date < end_date DO INSERT INTO calendar(Yr,Mo) VALUES(Yr,Mo); SET crt_date = ADDDATE(crt_date, INTERVAL 1 MONTH); END WHILE; END | DELIMITER ;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|I need to "lookback" and pull all data from 5pm and prior based on a date time field. Is there a getdatetime funcion?||4||28|
|SQL 2012 Report Builder 3.0 query||2||22|
|How can I group this data in the following manner?||2||24|
Join the community of 500,000 technology professionals and ask your questions.