Postgres Pro
Downloads
Home   >   mailing lists

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

From Stéphane DEWITTE
Subject Re: Need some help with dates
Date
Msg-id NOEAIPGJHJIHECKNEIBGIEHECOAA.stephane@smeso.fr
Whole thread Raw
In response to Re: Need some help with dates  ("Gautham S. Rao" <gautam.rao@tatainfotech.com>)
Responses Re: Need some help with dates  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
Tree view 
> Hi Stéphane,
>
> 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.

Thanks a lot ! That works !!

pgsql-sql by date:

Previous
From: "Gautham S. Rao"
Date:
Subject: Re: Need some help with dates
Next
From: "Miguel Carvalho"
Date:
Subject: Re: Need some help with dates