|
||
|
 |
|
||||||||||||||||||
|
#1
08-05-2010
|
|||
|
|||
SQL query help needed (Oracle)
Using Oracle SQP*Plus at the moment.
I have two dates in DATE format. I want to know if there is a way of deducting one date from the other (for example START_DATE and FINISH_DATE) to show EXPERIENCE. Anyone any ideas at all?? Thanks in advance 
__________________
Previously: BRCA Micro Section Chairman. BRCA Micro National Champion. Currently: JQ fan. Bellend. Forums are better than Facebook groups 
|
|
#2
08-05-2010
|
||||
|
||||
|
check this out http://psoug.org/reference/date_func.html
there is example with making diff function on the bottom
__________________
Retired from racing
| パベルともうします、よろしくおねがいしますスロバキア人だ、今イギリスにすんでいます。| | Ralls Racing | RCSGraphicWorx - paints, paintjobs, decals, custom wear | Schumacher Racing | Mr.O inserts |
|
 |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
