Date Function Usage – Informix Archive

Frankie — Mon, 13 Nov 2000 17:16:57 +0800 — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Frankie

Eric COQUIDE — Mon, 13 Nov 2000 11:26:10 +0100 — source: Informix-list mailing list archive (1991-1998)

my environment variable DBDATE is DMY4 and I use the date string "24/01/2000" Frankie <kehunchi@cm1.hinet.net> a 'crit dans le message : 8uobi7$3ic$1@news.is.net.tw... > 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 > > >

↪ replying to Frankie

Art S. Kagel — Mon, 13 Nov 2000 19:23:46 -0500 — source: Informix-list mailing list archive (1991-1998)

The user's environment variable DBDATE controls string to date interpretation as well as date to string formatting. Art S. Kagel Frankie wrote: > > 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