Re: TO_DATE defaults to Current Month - Please Help!
From: Steve Edelstein <74160.645_at_CompuServe.COM>
Date: 1995/11/30
Message-ID: <49l7gr$ln2$1_at_mhade.production.compuserve.com>#1/1
Date: 1995/11/30
Message-ID: <49l7gr$ln2$1_at_mhade.production.compuserve.com>#1/1
Don't you want to use HH:MI:SS? Using MM takes the month (as in DD-MM-YYYY); the minutes in the time portion have to be MI. (This, by the way, is a common mistake that people have been making since at least 1984!!! The more things change...)
-- Steve Edelstein VOICE: 212-956-3670 Relational Business Systems CompuServe: 74160,645 124 West 60th Street Suite 47C Author of New York, NY 10023 "Learning Oracle Forms"Received on Thu Nov 30 1995 - 00:00:00 CET