|
Subject:
|
Sending Date variable into Oracle Database
|
|
Posted By:
|
Judex
|
Post Date:
|
8/30/2003 9:10:47 PM
|
Hi,
I'm trying to implement an SQLJ application that is using date as a variable in its database. The problem is that I cannot send date values from Java to the Database. It considered as unknown values.Otherwise the program works fine.
judex
|
|
Reply By:
|
yasir_lahham
|
Reply Date:
|
9/20/2003 5:54:23 PM
|
Indeed, I had the same problem once, and I made some work around, by using the To_Date() function when passing the date value to Oracle, and it was working perfectly.
instead of passing the date to the database, send a string "to_date('your date value','format')"
hope that can help
MHD Yasir Al-lahham
|
