Re: Need some help with dates

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Stéphane DEWITTE <stephane(at)smeso(dot)fr>, "Gautham S(dot) Rao" <gautam(dot)rao(at)tatainfotech(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Need some help with dates
Date: 2002-04-17 16:16:24
Message-ID: web-1374322@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Stephane,

> > to_number works in the same fashion as in oracle. You need to give
> > to_number('<yourdata>','formatmask')
> > For example, to_number('1234567','FM9999999')
> >
> > Regards,
> > Gautham.

A list of PostgreSQL functions:
http://www7.us.postgresql.org/users-lounge/docs/7.2/postgres/functions.html

-Josh

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Stéphane DEWITTE 2002-04-17 16:18:15 Help with conversions (suite)
Previous Message Josh Berkus 2002-04-17 16:08:58 Re: [SQL] 16 parameter limit