Time / Date -fieldtype

From: Aarni Ruuhimäki <aarni(dot)ruuhimaki(at)kymi(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Time / Date -fieldtype
Date: 2003-03-04 13:48:51
Message-ID: 200303041548.51675.aarni.ruuhimaki@kymi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

BR,

--
Aarni Ruuhimäki
Megative Tmi
KYMI.com

Pääsintie 26
45100 Kouvola

info(at)kymi(dot)com / aarni(dot)ruuhimaki(at)kymi(dot)com

05 - 3755 035 / 050 - 4910 037

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2003-03-04 14:18:50 Re: Time / Date -fieldtype
Previous Message Tom Lane 2003-03-04 02:20:53 Re: Beginner's Luck