Re: inserting a date/time default into a column

You can do for example:
UPDATE table_name SET default_date=TO_DATE('1/1/1998, 8:00 A.M.', MM/DD/YYYY, HH:MI P.M.) For select
SELECT defaul_date FROM table_name
WHERE TO_CHAR(default_date)='the_date_in_your_default_format';

Regards,
Mike.

Laura Bellini wrote:

> Can someone explain to me how to insert a date/time default value into a
> column?
>
> Here's what I would like to do:
>
> default of 1/1/1998 08:00 (am) into a date column.
>
> Do I have to format it or what? Unfortunately, my Oracle documentation
> doesn't explain how to do this.
>
> Thanks.
>
> Laura Bellini
> laura_bellini_at_compaq.com
Received on Tue Jan 20 1998 - 00:00:00 CST