Re: Function to convert bigint to date

From: Steven Klassen <sklassen(at)commandprompt(dot)com>
To: "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Function to convert bigint to date
Date: 2004-10-21 16:17:38
Message-ID: 20041021161738.GA2946@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

* Pradeepkumar, Pyatalo (IE10) <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2004-10-21 16:26:47 DROP TABLE IF EXISTS
Previous Message Pradeepkumar, Pyatalo (IE10) 2004-10-21 14:47:21 Function to convert bigint to date