[GENERAL] How to implent the CONVERT ( data_type [ ( length ) ] , expression ) function in PostgreSQL

2014-11-02 Thread rohtodeveloper
Dear I'm doing a job about converting an expression of one data type to another.In SQLServer, there'are two functions to do this job. 1. CAST ( expression AS data_type [ ( length ) ] )2. CONVERT ( data_type [ ( length ) ] , expression ) However, In PostgreSQL, there's only the CAST ( expression A

Re: [GENERAL] How to implent the CONVERT ( data_type [ ( length ) ] , expression ) function in PostgreSQL

2014-11-02 Thread Emanuel Calvo
El 02/11/14 a las 07:15, rohtodeveloper escibiĆ³: > Dear > > I'm doing a job about converting an expression of one data type to > another. > In SQLServer, there'are two functions to do this job. > >From which data_type to which one? In psql, the option \dC, will give you the list of supported cas

Re: [GENERAL] How to implent the CONVERT ( data_type [ ( length ) ] , expression ) function in PostgreSQL

2014-11-02 Thread Adrian Klaver
On 11/02/2014 06:13 AM, Emanuel Calvo wrote: El 02/11/14 a las 07:15, rohtodeveloper escibiĆ³: Dear I'm doing a job about converting an expression of one data type to another. In SQLServer, there'are two functions to do this job. From which data_type to which one? In psql, the option \dC,