Postgres Pro
Downloads
Home   >   mailing lists

int to date - Mailing list pgsql-sql

From Daniel Drotos
Subject int to date
Date
Msg-id Pine.LNX.4.61.0507251046400.2731@mazsola.iit.uni-miskolc.hu
Whole thread Raw
In response to Re: getting back autonumber just inserted  (Vivek Khera <vivek@khera.org>)
Responses Re: int to date
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Mauricio Fernandez"
Date:
Subject: Re: Convert numeric to money
Next
From: Bruno Wolff III
Date:
Subject: Re: int to date