-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
LAFONTAINE Julien - LYO wrote:
> Hi Mark,
>
> Thank you for your help.
>
> I have the same problem when I execute the query with the MySQL client on my
> AIX server :
>
> mysql> select sum(AMFTPF) from DWH_AMF;
>
> +-+
> | sum(AMFTPF) |
, but maybe I'm doing something wrong.
Regards,
Julien
-Message d'origine-
De : Mark Matthews [mailto:[EMAIL PROTECTED]
Envoyé : lundi 21 février 2005 16:24
À : LAFONTAINE Julien - LYO
Cc : mysql@lists.mysql.com
Objet : Re: Problem with SUM and DECIMAL field
-BEGIN PGP
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
LAFONTAINE Julien - LYO wrote:
> Hi everyone,
>
> I've recentely upgarded my servers from MySQL 3.23.49 to MySQL 4.1.9.
>
> Now I have a problem when using the SUM operator on DECIMAL field.
>
> The value returned by the S
I've recentely upgarded my servers from MySQL 3.23.49 to MySQL 4.1.9.
>
> Now I have a problem when using the SUM operator on DECIMAL field.
>
> The value returned by the SUM operator when used with DECIMAL field has a
> coma (,) as decimal separator while it used to be have
Hi everyone,
I've recentely upgarded my servers from MySQL 3.23.49 to MySQL 4.1.9.
Now I have a problem when using the SUM operator on DECIMAL field.
The value returned by the SUM operator when used with DECIMAL field has a
coma (,) as decimal separator while it used to be have a dot (.) .
Hi all,
I have a MyISAM table with a decimal field (12,2)
I have loaded a bunch of data into this table, from ascii dumps of data being
migrated from other systems. Some of these dumps include a value for the
decimal field in the form of "00078000.00"
My understanding was that deci
Hello list,
I try to enter data via a remote Zeos SQL Componet from Borland c++ builder.
I have a decimal field in a table. The problem is when i enter for example
39.00 the table will show 39. If i enter 12.44 the value in the field shows
12.44
Is there a way to make 39.00 instead of 39