int to date

From: Daniel Drotos <drdani(at)mazsola(dot)iit(dot)uni-miskolc(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: int to date
Date: 2005-07-25 08:54:42
Message-ID: Pine.LNX.4.61.0507251046400.2731@mazsola.iit.uni-miskolc.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I have a string containing hexa dump of an 4 bytes integer, like
'6AF4805C'. Is it possible to convert it somehow to date type in
plpgsql (v8.0.0-rc1)? Doc says that date is represented as 4 bytes
internaly.

How can I get internal representation of a date type field? So I would
be able to produce hexa dump of it like above...

Daniel

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message jacekp 2005-07-25 12:58:43 update vs unique index
Previous Message Mauricio Fernandez 2005-07-25 07:59:05 Re: Convert numeric to money