Re: Convert date to string

Posted in 2007

Arturo Koosau — Fri, 9 Feb 2007 23:32:26 -0800 — source: Usenet: comp.databases.informix

You may want to try converting due_dt to a string within the openrowset command ... There must be some function that does that ... ie. to_char ( due_dt ) maybe ?? SELECT * FROM OPENROWSET('MSDASQL','DSN=DSN;Uid=Uid;Pwd=PWD;',' SELECT TO_CHAR(DUE_DT) FROM ii.PLSEL_NF') On 2/7/07, Art S. Kagel <kagel@bloomberg.net> wrote: > > mkarbarz@gmail.com wrote: > > On Feb 7, 3:59 pm, "mkarb...@gmail.com" <mkarb...@gmail.com> wrote: > > > >>I have this very simple query: > <SNIP> > > > > > I guess I should've specified - the database I'm querying in > > openrowset is a Unidata via a IBM Unidata ODBC driver; the query is > > run from within sql server 2005 > > Post to the UNIDATA newsgroup, there are few here who use that product. > > Art S. Kagel > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- The biggest oxymoron: common sense