Postgres Pro
Downloads
Home   >   mailing lists

Re: Extracting time from timestamp - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: Extracting time from timestamp
Date
Msg-id 200303210859.39903.shridhar_daithankar@persistent.co.in
Whole thread Raw
In response to Extracting time from timestamp  ("Shridhar Daithankar<shridhar_daithankar@persistent.co.in>" <shridhar_daithankar@persistent.co.in>)
List pgsql-general
Tree view 
On Friday 21 Mar 2003 12:04 am, Darren Ferguson wrote:
> If the field is definately a timestamp field just do the following
>
> SELECT TO_CHAR(stime,'HH24:MI') FROM bookings;

Problem is I want timestamp out of it, not char. representation because I have
to compare quite a few of them. That's where I am stuck..

 Shridhar

pgsql-general by date:

Previous
From: "Thomas T. Thai"
Date:
Subject: Re: TSearch Related? - ERROR: datumGetSize: Invalid typLen
Next
From: "Thomas T. Thai"
Date:
Subject: pg_restore and adding a column