Re: Default value question for dates
From: <fgreene_at_hayes.com>
Date: 10 Aug 93 07:33:55 EDT
Message-ID: <7756.2c674f63_at_hayes.com>
Date: 10 Aug 93 07:33:55 EDT
Message-ID: <7756.2c674f63_at_hayes.com>
In article <1993Aug09.143647.33997_at_source.asset.com>, mcconnel_at_source.asset.com (Andrew McConnell) writes:
> I'm trying to insert a default value into a date field
> using SQLFORMS 3.0.
>
> I've tried several approaches (inc. $$DATE$$+365) and none seem
> to work without error.
>
> Can anyone help me???
>
> Thanks in advance
>
easiest way is to use a convenient trigger (on-new-field-instance, post-query,
etc) and simply set the field, as in
the_date_field := SYSDATE; Received on Tue Aug 10 1993 - 13:33:55 CEST