RE: date conversion: date - datetime with EXTEND

Try: EXTEND(date('1/1/2007'),YEAR TO SECOND) j. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Martin Thole Sent: Wednesday, November 21, 2007 8:02 AM To: informix-list@iiug.org Subject: date conversion: date - datetime with EXTEND Situation: data field StartDate with data type: datetime year to second With the SQL statement: select count(*) from table where StartDate = EXTEND ('1/1/2007',YEAR TO SECOND) i got error -1262 "on numeric character in datetime or interval". What' s wrong ? Without EXTEND - as text literal - the sql statement is o.k. select count(*) from table where StartDate = '2007-01-01 00:00:00' Thanks for your tips Martin Thole _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list