Postgres Pro
Downloads
Home   >   mailing lists

How to extract hour and minutes from a timestamp - Mailing list pgsql-novice

From Tan ga
Subject How to extract hour and minutes from a timestamp
Date
Msg-id 20021017175001.5E5AB47590C@postgresql.org
Whole thread Raw
Responses Re: How to extract hour and minutes from a timestamp  (Andrew McMillan <andrew@catalyst.net.nz>)
Re: How to extract hour and minutes from a timestamp  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-novice
Tree view 
Hi again :)

I already resolver my other problem but now i would like to extract both
time and hour from a timestamp in order to compare with a string.
Ex 2000-01-01 19:30:00
I want the result to be 19:30

With select substr(....) i can do this but that's not what i want.

I'm using python with postgres.
--
10Mb na sua caixa de email gratuita no mail.pt
http://www.mail.pt

pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: char() or varchar() for frequently used column
Next
From: Andrew McMillan
Date:
Subject: Re: How to extract hour and minutes from a timestamp