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

What I would like to do is find the number of consecutive weeks that someone is active on Sundays a… Read more How Can I Find Consecutive Active Weeks In Sql?

Need some help with this: Create a table called TEMP_STUDENT with the following columns and cons… Read more Check Constraint To Restrict The Registration Date To Dates After August 26, 2005

Here is my solution, I want to display all the information in 3 tables with salary, when I put sal… Read more Ora-00904: Invalid Identifier In This Instance

I am currently creating a Delphi Application with SQL connections integrated. SQL stores its date v… Read more Delphi Sql Date Reading Issue

How to fill missing dates and values in partitioned data? I'm having a lot of trouble Googling … Read more How To Fill Missing Dates And Values In Partitioned Data?

I have field REPORTDATE (DATETIME). In SQL Developer i can see its value in this format 29.10.2013 … Read more Oracle Sql "select Date From Datetime Field "

I have spent days trying to figure out how to add missing dates with the nearest values in Hive wit… Read more Hive Sql Query To Fill Missing Date Values In Table With Nearest Values

I'm creating a query where I'm showing the different statuses a member has had, and how lon… Read more Trying To Arrange Sql Query To Properly Use Datediff()

I am trying to convert EEE MMM dd HH:mm:ss ZZZ yyyy to YYYY-MM-DD format, so I can insert it into a… Read more "eee Mmm Dd Hh:mm:ss Zzz Yyyy" Date Format To Java.sql.date

I have a table called users and In sql the format of date is yyyy-mm-dd there fore when I try to en… Read more Change Date Format To Dd/mm/yyyy In Sql

Is there something similar to DATEFROMPARTS(year, month, day) in SQL Server 2008? I want to create … Read more Creating Date In Sql Server 2008

In continuation of Find entry where value does not intersect with other value I have an application… Read more Implementation Of Blocked Dates For A User-event Orm Model