| From: | "Gary MacMinn" <G(dot)MacMinn(at)nca(dot)gov(dot)au> |
|---|---|
| To: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Updating datetime fields with NULL values |
| Date: | 1999-11-16 22:28:34 |
| Message-ID: | s832757b.009@syd_aux.nca.gov.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Morning All,
Is it possible to clear a datetime field to NULL? If so, how? In trying an update (update test set d1='' where t1='Text2';) I get an error of Bad datetime external representation ''
TIA,
Gary MacMinn
===============================================
Table = test
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| t1 | text | var |
| d1 | datetime | 8 |
+----------------------------------+----------------------------------+-------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Ziniti | 1999-11-16 22:58:09 | Re: [SQL] Updating datetime fields with NULL values |
| Previous Message | maxsbox | 1999-11-16 18:17:07 | ODBC/Openlink/Delphi |