Function to convert bigint to date

From: "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Function to convert bigint to date
Date: 2004-10-21 14:47:21
Message-ID: 77ED2BF75D59D1439F90412CC5B109741381EDED@ie10-sahara.hiso.honeywell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Hi all,
For my application we are storing the date information by casting it into
BIGINT using the following
extract('epoch' from current_timestamp)::bigint

But how do I convert the BIGINT to the date format 'dd mm yyyy' a function
similar to to_date(text,text)
Is there any function to do this conversion.

Thanks in advance

With Best Regards,
Pradeep Kumar P.J

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Steven Klassen 2004-10-21 16:17:38 Re: Function to convert bigint to date
Previous Message padma k 2004-10-21 05:13:32 windows version