Hi,
I think the problem is the double quote you use. Try a single quote e.g.:
update yourtable set birthdate='200-01-01' where ...
This man must be a very old one... :)
I tried it using timestamp not date, but I think it should work as well.
bye,
-- cs.
-Original Message-
From: [EMAIL
--- Begin Message ---
EMS has a tool called EMS PostgreSQL Database Comparer.
http://www.sqlmanager.net/products/postgresql/dbcomparer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Sunday, 19 December 2004 1:23 AM
To: [EMAIL PROTECTED]
Subject: [SQL] diff dat
hi all,
Ca anyone send me an example how to update a date datatype?
for example
update table set birthdate = "200-01-01" doesnt work.
TIA
Pablo
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I can't figure out an efficient way to do this. Basically I had a typical 3-tier relationship:
(Employee -> Department -> Division)
However, at some point the need to move employees arose, but instead of changing the key in the emp table, we now have
an over-ride table, so a history can be tracked
Mark Collette wrote:
Now, I've added the infrequentId columns to both, as an optimization, so
that I can quickly find the InfrequentTable entry for a given
FrequentTable entry. I've done this because I want to speed up
SELECTs. Any new INSERTs are working just fine. But, all my legacy
entrie
