Re: PG sql string -> time_t - Mailing list pgsql-general

From Bo Lorentsen
Subject Re: PG sql string -> time_t
Date
Msg-id 1008684816.580.11.camel@debian
Whole thread Raw
In response to Re: PG sql string -> time_t  ("Andrew Snow" <andrew@modulus.org>)
List pgsql-general
On tir, 2001-12-18 at 15:03, Andrew Snow wrote:
>
> Perhaps this will help? Extract(epoch ..) eg:
>
>   SELECT EXTRACT(EPOCH FROM date_field) FROM record;
>
> returns the time in seconds since the epoch like time() in C
Thanks, this could be a solution, but I was working on a more general
way of interpreting the date, time and datetime string into a more
computer friendly format (ei. time_t), for a more generic usage.

/BL


pgsql-general by date:

Previous
From: "Andrew Snow"
Date:
Subject: Re: PG sql string -> time_t
Next
From: Steffen Schmidt
Date:
Subject: pg_dump - problem