| From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Leslie Mikesell <les(at)Mcs(dot)Net> |
| Subject: | date type conversions |
| Date: | 1998-05-14 00:17:22 |
| Message-ID: | Pine.BSF.3.96.980513211642.438D-100000@thelab.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
===================================================================
This message has been sent to a DEAD mailing list, and subsequently
reforwarded to the proper one: pgsql-general(at)postgresql(dot)org
===================================================================
How can I tell if an automatic type conversion will be done on
a particular field? For example, given a datetime field d, why
does psql accept set d = 'now()' but require set d = datetime(now())
without the ''s? Datetime's seem to work through ODBC to Access
where timestamps turn into text...
Les Mikesell
les(at)mcs(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lau,Harald | 1998-05-14 19:35:21 | Tcl-interface |
| Previous Message | Victor M. Mondragon A. | 1998-05-13 21:58:57 | TPC C & D Benchmarks |