DA0003 error

[system]

Something similar was discussed on BOB. Please go through that discussion I think is help for you?

120×120 10.4 KB

Hi, Have a time stored in an Oracle Database (9i) as number(5,2). Normally I’d use the to_date function to specify what I want eg to_date(table.column, ‘HH24:MM’). However, when I do this I get the following error : Error during SQL execution: (DA0003) Details: Exception: DBD, ORA-01840: input value not long enough for date format State: N/A I suspect it’s something to do with the decimal place but have tried a few things unsuccessfully. Anyone any ideas? Thanks. Steve Steve…

---

suhas.BOBI (BOB member since 2010-12-09)