Hi there,
I 'll not be solving your problem but I have got two clues for you:
- looks like you got your dates stored in character columns
You 'll need the TO_DATE function with a nice formatting
string to make these values real dates (
- in Oracle SQL the difference between two date values is always a number of days, so you 'll have to multiple it by 24 * 3600 to get seconds.
Good luck,
Rudy.