Look at Oracle's TO_CHAR() and TO_DATE() functions. Thanks, Robin Greenhagen President GreenSoft Solutions, Inc. http://www.greensoft.com/
> -----Original Message----- > From: Smith, Jim [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 17, 2001 9:55 AM > To: KCFusion > Subject: [KCFusion] Date > > > How do I format a date to insert into an oracle table when I > want to have > the date/time as mmddyyyyhhmiam? I keep getting format errors. > > > ______________________________________________________________________ > The KCFusion.org list and website is hosted by Humankind Systems, Inc. > List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org > Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] > To Subscribe.................... mailto:[EMAIL PROTECTED] > To Unsubscribe................ mailto:[EMAIL PROTECTED] > > ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]