Re: [SQL] excel vs. money data type? - Mailing list pgsql-sql

From David Hartwig
Subject Re: [SQL] excel vs. money data type?
Date
Msg-id 35E40584.3B11394F@insightdist.com
Whole thread Raw
In response to excel vs. money data type?  (Leslie Mikesell <les@Mcs.Net>)
Responses Re: [SQL] excel vs. money data type?
List pgsql-sql
This sounds like a bug I came across a while ago.   Since then, I abandon money in
favor of float.   I suspect it has to do with the leading "$" and the a conversion
to a number.   It looks like it has slipped through the proverbial crack.   In any
case, it will be about a week until this can be addressed.


Leslie Mikesell wrote:

> Is there any way to get a pgsql MONEY data type into excel (office 95 version)
> using the odbc driver?  I can see the values in the preview doing the
> query but they come in as zeros when I click the 'Return Data to
> Microsoft Excel' menu.  I can get them in Access and export the table
> to an Excel file but I want a canned query that someone else can
> run using only Excel.
>




pgsql-sql by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: [SQL] parts of date_part()
Next
From: Leslie Mikesell
Date:
Subject: Re: [SQL] excel vs. money data type?