On Tue, Mar 04, 2003 at 15:48:51 +0200,
Aarni Ruuhimäki <aarni(dot)ruuhimaki(at)kymi(dot)com> wrote:
> Hi folks !
>
> What is the proper type for date or timestamp so that the field can also be
> null or empty when inserting new rows?
>
> I have to have fields for applied, accepted and renewed for a product license
> and not all are necessarily present when creating a new product. Now I get
> 'bad timestamp external representation' for an empty form field.
'' is not the same as NULL .
Your app probably needs to look for empty date and/or timestamp strings
and replace them with NULL .