Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

BUG #4207: EXTRACT function


  • From: "Jeferson Kasper" <jefersonkasper(at)gmail(dot)com>
  • To: pgsql-bugs(at)postgresql(dot)org
  • Subject: BUG #4207: EXTRACT function
  • Date: Thu, 29 May 2008 07:01:46 GMT
  • Message-id: <200805290701(dot)m4T71kVf068203(at)wwwmaster(dot)postgresql(dot)org>

The following bug has been logged online:

Bug reference:      4207
Logged by:          Jeferson Kasper
Email address:      jefersonkasper(at)gmail(dot)com
PostgreSQL version: 8.1.5
Operating system:   Windows XP and Linux Redhat
Description:        EXTRACT function
Details: 

Hello.
First... sorry for poor english :)
My problem is quite simple.
the EXTRACT(field FROM source) function allows to use some kind of 'fields',
and i need to know if a time (like '07:00') is after the midday(12:00) or
not.
I know i can resolve it implementing some function like "select
('07:00'<'12:00')".. i just want to know if is difficult to implement a new
field called 'am', to use like.

select extract(AM from '07:00');

?column?
--------
t

i hope its not difficult, and i should use it, if it become available ...

Thanks for all.



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group