I'm writing an oracle script and i noticed a table with column "time" was set to datatype number. Ideally I'd like them as a value oracle recognizes as time. I want to put (for example) 18:21 into my table. I tried with timestamp and had no success then I tried date and had no success again!
The times are not values for comparing or calculating. In my case its what time to pickup someone from a wedding. I have the wedding date in a separate column so I don't want the full 7 character values assigned by timestamp just 4 digits with just 18:21 in...
Any ideas would be great and i really appreciate any help i get.
Thanks a lot