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

I'm struggling with creation of select which shows me penultimate date for each record in my DB… Read more Penultimate Date For Each Record

We are using SQL Server. In our CASE WHEN statement, I need to check if the number of days between … Read more Sql Server Query To Get The Number Of Business Days Between 2 Dates, Excluding Holidays