Home > mailing lists

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

From	Steven Klassen
Subject	Re: Function to convert bigint to date
Date	October 21, 2004 20:17:47
Msg-id	20041021161738.GA2946@commandprompt.com Whole thread Raw
In response to	Function to convert bigint to date ("Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar.Pyatalo@honeywell.com>)
List	pgsql-novice

Tree view

* Pradeepkumar, Pyatalo (IE10) <Pradeepkumar.Pyatalo@honeywell.com> [2004-10-21 07:47:21 -0700]:

> But how do I convert the BIGINT to the date format 'dd mm yyyy' a
> function similar to to_date(text,text)

This reply from Richard Huxton should do the trick:

http://archives.postgresql.org/pgsql-sql/2002-07/msg00397.php

--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564

pgsql-novice by date:

From: "Pradeepkumar, Pyatalo (IE10)"
Date: 21 October 2004, 18:48:20
Subject: Function to convert bigint to date

From: Sean Davis
Date: 21 October 2004, 20:25:55
Subject: DROP TABLE IF EXISTS

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

Previous

Next