Re: TO_DATE defaults to Current Month - Please Help!
From: Govindhan Padmavijayam <govind_at_bns01.attmail.com>
Date: 1995/11/29
Message-ID: <DIt7MD.EqD_at_nntpa.cb.att.com>#1/1
Date: 1995/11/29
Message-ID: <DIt7MD.EqD_at_nntpa.cb.att.com>#1/1
Charlie Kempson <kempsonc_at_logica.com> wrote:
>When calling TO_DATE ("13:00:00", "HH:MM:SS") during
>an Oracle insert the YY:MM:DD fields are defaulting
>to the 1st of the current month. This is all very well
>until next month comes along - then all the update
>clauses stop working!
>
>Does anybody know how to make Oracle use a fixed default
>for it's YY:MM:DD. We would love to use 01:01:00!
>
>Thanks in advance - please mail as well as posting...
>
>Charlie Kempson
>mailto:kempsonc_at_logica.com
>
Change MM to MI !! ( MM = month, hence the current month / MI = minutes ).
Govind. Received on Wed Nov 29 1995 - 00:00:00 CET