Re: [SQL] converting big int to date

2011-03-24 Thread Vibhor Kumar
On Mar 24, 2011, at 2:42 AM, Sree wrote: > How can i convert bigint to date format. > > bigint=6169625280 Please explain what;s this value shows. Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company vibhor.ku...@enterprisedb.com Blog:http://vibhork

Re: [SQL] converting big int to date

2011-03-24 Thread Sree
How can i convert bigint to date format. bigint=6169625280

Re: [SQL] pg_attributte, data types

2011-03-24 Thread Viktor Bojović
On Thu, Mar 24, 2011 at 12:56 AM, Tom Lane wrote: > =?UTF-8?Q?Viktor_Bojovi=C4=87?= writes: > > while listing data types i have noticed that some types have underscore > > prefix but i don't know why is that. so im asking if somene can tell me. > > These are type examples: > > > _char > > _float