Re: sqlloader and date masks

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Wed, 31 Mar 1999 21:10:26 +0200
Message-ID: <7dtrv3$pk1$1@weber.a2000.nl>

Marc Mazerolle wrote
> first_set date "YYYY/MM/DD HH24:MI:SS" "trunc(:FIRST_SET)"

Good options. If first_date would always need the time part to be removed, then another option would be a database trigger:

    create or replace triiger biu_my_table

        on insert or update on my_table
        for each row
    begin
        :new.first_date := trunc( :new.first_date);

    end;
    /
    show errors

Arjan. Received on Wed Mar 31 1999 - 13:10:26 CST