Postgres Pro
Downloads
Home   >   mailing lists

Re: Need some help with dates - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Need some help with dates
Date
Msg-id web-1374322@davinci.ethosmedia.com
Whole thread Raw
In response to Re: Need some help with dates  (Stéphane DEWITTE <stephane@smeso.fr>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to reset sequences on pre-7.1
Next
From: Stéphane DEWITTE
Date:
Subject: Help with conversions (suite)