0

I have four fields:

  • Start_Date = 16-Jun-10
  • Start_Time = 14:37
  • End_Date = 16-Jun-10
  • End_Time = 14:38

I need to calculate the difference from start to end. I tried using the to_date(Start_date || Start_Time) but keep getting this error message:

ORA-01830: date format picture ends before converting entire input string 01830.00000 - "date format picture ends before converting entire input string"

Thank you for your help. David

OMG Ponies
  • 325,700
  • 82
  • 523
  • 502
David
  • 31
  • 1
  • 2

1 Answers1

5
to_date(Start_date||start_time,'DD-MON-YYHH24:MI')
rfusca
  • 7,435
  • 2
  • 30
  • 34