I have written a Pro*C program to do inserts into an Oracle database, but the data includes dates and times. The Pro*C manual is a bit sketchy on the subject of using dates on insert statements, so I was wondering is anyone out there has any experience of doing this. I have tried passing the date through as a varchar in different formats eg, dd-mon-yy hh:mm:ss; dd-mon-yyyy hh:mm:ss; dd-mm-yyyy hh:mm:ss etc, and even tried embedding a to_date(..) in the sqlstring, but I keep getting error messages. Brick wall here's my head situation. There is a date data type but absolutely no guidance on how to use it. My current thought is to cycle through each byte of the date variable, setting is hex value. Maybe?
Ideas anyone?