How to extract hour and minutes from a timestamp

From: Tan ga <gndtanga(at)mail(dot)pt>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to extract hour and minutes from a timestamp
Date: 2002-10-17 16:52:05
Message-ID: 20021017175001.5E5AB47590C@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andrew McMillan 2002-10-17 19:34:19 Re: How to extract hour and minutes from a timestamp
Previous Message Josh Berkus 2002-10-17 16:16:50 Re: char() or varchar() for frequently used column