>i need a way to show only the date on a datatime field for the user update. thanks...
When you create the SQL to Oracle use the TO_CHAR function:
Select ..., to_char(date_field, 'MM/DD/YYYY') as 'Date Field' ...
The 2nd parameter of the to_char can be any valid date format as long as you use M for month, D for day, Y for Year. e.g., YY-MM, YY.MM.DD, YYYY.MM.DD, etc., all should work. A good Oracle reference book should give you better ideas on what you can do for to_char formatting of returned rows for numeric, date, etc., fields.
Mark McCasland
Midlothian, TX USA