|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
March 31st, 2008, 09:40 PM
|
|||
|
|||
|
Difference in date columns transposed as rows
Hi,
I need to transpose the diffrence between two date columns as the total number of rows in the result set. For example: Temp: t1 sno date1 date2 1 12/03/2007 14/03/2007 2 13/03/2007 16/03/2007 Expected output sno date 1 12/03/2007 1 13/03/2007 1 14/03/2007 2 13/03/2007 2 14/03/2007 2 15/03/2007 2 16/03/2007 Thanks in advance for the help.
|
|
| Viewing: Dev Shed Forums > Databases > DB2 Development > Difference in date columns transposed as rows |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
