Re: [SQL] int to date

2005-07-25 Thread Bruno Wolff III
On Mon, Jul 25, 2005 at 10:54:42 +0200, Daniel Drotos <[EMAIL PROTECTED]> wrote: > 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 >

[SQL] int to date

2005-07-25 Thread Daniel Drotos
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