I was wondering if somebody could point me in the right direction.
I'm situated in Brazil and recently daylights savings/summer timekicked in and clocks were set one hour ahead. Now on my windows box the system clock automatically adjusted to the correct time. But performingthe following query on
I followed your instructions and now() indeed returned the correct time!
Thanks for your help
On 11/9/05, Michael Fuhr [EMAIL PROTECTED] wrote:
On Wed, Nov 09, 2005 at 02:24:28PM -0200, Giovanni M. wrote: I'm situated in Brazil and recently daylights savings/summer time kicked in
and clocks were
Hi guys,
I am searching for a function that enables me to strip the trailing
zeros in the fractional part of a number (numeric type). For example a
number saved in a column of type numeric as such: 23.45000 would be
returned as 23.45
I can't find any function that does this in the documentation,
Round and trunc dont provide the functionality I need.
Say for example I have two values in a column of type numeric as follows:
23.455
12.300
What I need to happen is stripping the useless zeros in the
fractional part of numbers so 12.300 would become 12.3 and 23.455
would stay the same
Round
Yes! That did it, thanks for the help
On 10/3/05, Tony Wasson [EMAIL PROTECTED] wrote:
On 10/3/05, Giovanni M. [EMAIL PROTECTED] wrote:
Round and trunc dont provide the functionality I need.
Say for example I have two values in a column of type numeric as follows:
23.455
12.300
ok guys thanks for the help. I will follow this advice to upgrade my
existing installation, I have already dumped by database as i keep
backups of course, and Im sure I can figure it out. I was just hoping I
didnt need to do much manual work, alas.
gioOn 8/15/05, Magnus Hagander
[EMAIL
Hello,
Wondering if somebody can help me out with upgrading a PostgreSQL 8.0.2 installation on Windows XP SP2.
I canĀ“t seem to upgrade to 8.0.3 on a Windows XP Machine. The machine has a limited user account running the pgsql-8.0 service. The first installation was performed succesfully with the