Re: inserting a date/time default into a column

Laura Bellini wrote:

> default of 1/1/1998 08:00 (am) into a date column.
>

When you create the column in the table use something like:

CREATE TABLE FOO(
    BAR INTEGER,
    TRUND DATE DEFAULT TO_DATE('01/01/1998 08:00','MM/DD/YYYY HH24:MI')    );

BTW, the email address you set as the Reply-To: has an error. There is a right square bracket between .com and >

-- 
James "I'd rather fall off Ilustrada than ride any other horse" Petts