Re: PG sql string -> time_t

From: Bo Lorentsen <bl(at)netgroup(dot)dk>
To: Andrew Snow <andrew(at)modulus(dot)org>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PG sql string -> time_t
Date: 2001-12-18 14:13:35
Message-ID: 1008684816.580.11.camel@debian
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steffen Schmidt 2001-12-18 14:39:40 pg_dump - problem
Previous Message Andrew Snow 2001-12-18 14:03:13 Re: PG sql string -> time_t