> I already resolver my other problem but now i would like to extract
> 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
Check out "Functions and Operators" in the online user manual.
What you want is:
SELECT to_char(some_timestamp, 'HH:MI');
In response to
pgsql-novice by date
|Next:||From: Randy Neumann||Date: 2002-10-17 20:15:11|
|Subject: Re: char() or varchar() for frequently used column|
|Previous:||From: Andrew McMillan||Date: 2002-10-17 19:34:19|
|Subject: Re: How to extract hour and minutes from a timestamp|