Path: utzoo!attcan!uunet!ncrlnk!ncrwic!sfc!chas From: chas@sfc.Wichita.NCR.COM (Charles Binford) Newsgroups: comp.databases Subject: Date/Time in Oracle SQL-Forms, how to do it? Keywords: Oracle SQL-Forms Message-ID: <690@sfc.Wichita.NCR.COM> Date: 28 Jun 90 14:19:18 GMT Distribution: na Organization: NCR Corporation, Wichita, Kansas Lines: 17 How does one setup a form to handle input/update/display of an oracle database DATE field in a Form. All works fine if you don't mind every date having a time of 12:00 a.m. (00:00:00). The Designer's reference mentions something having to use to_date and to_char to convert back and forth between the form and the table. It is not very specific. I have tried several things but have yet to come up with the magic trick. Any help would be appreciated (especially if it contains specific instructions on how to setup the triggers). Thanks, Charles. We're using Oracle 5.1. -- Charles Binford, Automation Engineering, NCR PPD Wichita