Re: Default time not 12:00:00?

Todd Boss wrote:
> Apologies if this is a known issue.
>
> What is the default time inserted to a date field, if you don't
> specify one? I would have assumed it was 12:00:00 (00:00:00 in
> 24-hour time), but look at this sequence of statements:
>
> version: Oracle8i Release 8.1.6.1.0 - Production
>
> SQL> create table date_test
> 2 (col1 int null, col2 date null);
>
> Table created.
>
> SQL> insert into date_test values (1,'17-Apr-03');
>
> 1 row created.
>
> Commit complete.
> SQL> select col1, to_char(col2,'mm-dd-yyyy hh:mm:ss') from date_test;
>

Try mm-dd-yyyy hh:mi:ss as a format mask, that's mi, not mm for minutes

-- 
Regards, Frank van Bortel