Re: Data Conversion - Informix 5

Posted in 2000

Obnoxio The Clown — Tue, 25 Apr 2000 15:11:33 BST — source: Informix-list mailing list archive (1991-1998)

From: "Perry Provost" <perry.provost@compaq.com> > Could anyone tell me the correct SQL syntax in Informix 5 to convert >between the following > datatypes : > > date -> varchar > number -> char Informix will do an implicit type conversion, so you could just insert into newtable select .... from oldtable________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com