Re: Time / Date -fieldtype

Hi !

And thanks.

INSERT INTO .... VALUES(<cfif Trim(applied) is "">NULL<cfelse>'#applied#',
...)

BR,

aarni

On Tuesday 04 March 2003 16:18, you wrote:
> On Tue, Mar 04, 2003 at 15:48:51 +0200,
>
>   Aarni Ruuhimäki <aarni.ruuhimaki@kymi.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 .
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
Aarni Ruuhimäki
Megative Tmi
KYMI.com

Pääsintie 26
45100 Kouvola

info@kymi.com / aarni.ruuhimaki@kymi.com

05 - 3755 035 / 050 - 4910 037

*****************************************
Linux RedHat 7.3 / KDE 3.x Desktop
*****************************************