Using dates in Pro*C
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?