Function to convert bigint to date - Mailing list pgsql-novice

From Pradeepkumar, Pyatalo (IE10)
Subject Function to convert bigint to date
Date
Msg-id 77ED2BF75D59D1439F90412CC5B109741381EDED@ie10-sahara.hiso.honeywell.com
Whole thread Raw
Responses Re: Function to convert bigint to date  (Steven Klassen <sklassen@commandprompt.com>)
List 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

pgsql-novice by date:

Previous
From: padma k
Date:
Subject: windows version
Next
From: Steven Klassen
Date:
Subject: Re: Function to convert bigint to date