Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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