RE: Date Function Usage

Posted in 2000

Robert Stuart — Mon, 13 Nov 2000 14:31:22 +0000 — source: Informix-list mailing list archive (1991-1998)

Well, I'd write it update transtemp set t_exdt= "1999/01/01" where t_exdt < "1999/01/01" Otherwise, I cann't see much wrong (I presume function year(date) works!) -----Original Message----- From: Frankie [mailto:kehunchi@cm1.hinet.net] Sent: 13 November 2000 12:48 To: informix-list@iiug.org Subject: Date Function Usage Dear all: I have a sql syntax problem: update transtemp set t_exdt= "1999/01/01" where year(t_exdt) < 1999 || || Date Field How does "String Type"transform to "Date Type"? Thank's for your help. -- Frankie Ke Colovos Machinery Corp TEL:(04)4070810*203 FAX:(04)-4071129 Email:kehunchi@cm1.hinet.net