Re: TO_DATE defaults to Current Month - Please Help!

troy_at_corvu.com.au (Troy Rollo) wrote:

> 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 think that second MM will cause some problems (MI).

> 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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Chris Kasten
Programmer/Analyst (among others...)

#include <sys/std_disclaimer.h>

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Received on Thu Nov 30 1995 - 00:00:00 CET