Re: TO_DATE defaults to Current Month - Please Help!
From: Troy Rollo <troy_at_corvu.com.au>
Date: 1995/11/29
Message-ID: <49ildv$k12_at_hannibal.corvu.com.au>#1/1
Date: 1995/11/29
Message-ID: <49ildv$k12_at_hannibal.corvu.com.au>#1/1
In article <49fgp5$11_at_romeo.logica.co.uk>, kempsonc_at_logica.com says...
>
>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...
TO_DATE('1-01-1900 ' || '13:00:00', 'DD-MM-YYYY HH:MM:SS')
I've assumed you really wanted a variable in place of the time.
Troy Rollo Technical Director
troy_at_corvu.com.au CorVu Pty Ltd
Critic: Someone who can't and doesn't, but criticises those who can and do
Received on Wed Nov 29 1995 - 00:00:00 CET