pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Bu, Ning <NBU@pcgus.com>
To: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: set decimal point in SQL
Date: Mon, 16 Jun 2003 17:02:34 -0500
Message-ID: <B0D78FC4B536D6118D5A006097B658DE2A2C45@PCGSSU2> (raw)

 
 
 
I have a field set up as money and I try to calculate some number and put in
this field, but the number will be 6 demical point and I want to cut it to
only 2-4 decimal point, how can I do it? Thanks

Attachments:

image001.jpg (image/jpeg, 2.9K) download
  view image

view thread (3+ messages)  latest in thread

Message-ID: <B0D78FC4B536D6118D5A006097B658DE2A2C45@PCGSSU2>
Permalink:  ../B0D78FC4B536D6118D5A006097B658DE2A2C45@PCGSSU2/
Also on:    postgresql.org/message-id/B0D78FC4B536D6118D5A006097B658DE2A2C45@PCGSSU2

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: NBU@pcgus.com
  Subject: Re: set decimal point in SQL
  In-Reply-To: <B0D78FC4B536D6118D5A006097B658DE2A2C45@PCGSSU2>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox