Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic Date List

Status
Not open for further replies.
tangocasa

tangocasa

Vendor
Jul 5, 2001
6
US
I need to be able to create a dynamic list of dates. I would prefer to find a way to do it in a query instead of building a procedure to accomplish the goal.

The user will be passing in a starting and ending date. I want to take these and somehow generate a list of all possible dates between the two. Then these will be outer joined to another table to fill in gaps in the data.

tangocasa
 
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
4K
carp
carp
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
701
SkipVought
S
EM1107
  • Locked
  • Question
Insert date and time using UTC time in a DATE column
Replies
14
Views
945
EM1107
EM1107
Livia8
  • Locked
  • Question
How to list all the CPU (EBS) patches applied - Oracle 11.2.0.4.
Replies
3
Views
190
Livia8
Livia8
kernal
  • Locked
  • Question
If Day of the Week='Y' (i.e. Mon='Y') and between a Start Date and End Date then Count #of Days 1
Replies
1
Views
150
Beilstwh
Beilstwh

Part and Inventory Search

Sponsor

Back
Top