Home -> Usenet -> comp.databases.oracle -> TO_DATE function question

TO_DATE function question

From: Gretchen M. Lenze <gml_at_icf.hrb.com>
Date: 1 Jul 93 14:40:05 EST
Message-ID: <1993Jul1.144005.20361_at_icf.hrb.com> 







I am having the following problem with the "TO_DATE" function ... can
anyone help me out?



I am trying to update a field of type DATE with a date in the form


	Thu Jul  1 11:00:00 1993
           ^   ^^ ^        ^





To do this I use the call:


	insert into testtable(testcolumn) values (
		TO_DATE('Thu Jul  1 11:00:00 1993',
		DY Mon DD HH24:MI:SS YYYY'));





My problem is that in my date string, UNIX puts a blank before the
day if the date is earlier than the 10th of the month, and ORACLE
expects a leading 0 (or _something_ other than a blank).  Is there
a way to get around this problem without inserting a leading zero
if the date is only one digit?



Thanks in advance,


Gretchen Lenze


gml_at_icf.hrb.com


HRB Systems, Inc.


State College, PA
Received on Thu Jul 01 1993 - 21:40:05 CEST












Original text of this message