Lab Sql

I've been wondering - I have a lot of use with sysdate on my system, and when comparing it to m… Read more Oracle - Get Current Date Formatted

I just want a quick way (and preferably not using a while loop)of createing a table of every date b… Read more How To Get A Table Of Dates Between X And Y In Sql Server 2005

Example today's @date = 2010-02-22 14:17:19.393 Number @weeks = 2 Equation I am looki… Read more Calculate Date From The Difference In Weeks

I have publish up date and publish down date in my DB. Currently they are both same dates. How do I… Read more Add 30 Days For Date In Db

I have this table named people with two dates on MySQL: | Name | start_date | end_date | | John |… Read more Select A Sequence Between Two Numbers On Mysql

I have some data that contains dates. I'm trying to group the data by consecutive dates, howeve… Read more Group Records By Consecutive Dates When Dates Are Not Exactly Consecutive