Article View: chile.comp.programacion
Article #3024Re: consulta sql
From: Jos� Miguel Santib��ez
Date: Sat, 11 Jun 2005 03:50
Date: Sat, 11 Jun 2005 03:50
24 lines
1777 bytes
1777 bytes
En el cap�tulo anterior (news:d8dgt3$hnd$1@helcaraxe.dcc.uchile.cl),
Manuel Villarroel <mavillarNOALSPAM@decece.uchile.cl> dijo:
> es postgresql.
>
Seg�n manual:
http://www.postgresql.org/docs/8.0/interactive/functions-datetime.html
extract(hour from source)
extract(minute from source)
(De paso, encuentro grandiosa esta declaraci�n:
The first century starts at 0001-01-01 00:00:00 AD, although they did not
know it at the time. This definition applies to all Gregorian calendar
countries. There is no century number 0, you go from -1 to 1. If you
disagree with this, please write your complaint to: Pope, Cathedral
Saint-Peter of Roma, Vatican.
)
--
Jose M. Santiba�ez A.
<jms@nivel5.cl>
<http://caos.cl/jms>
Technical Details
Message-ID:
<Xns9671F176073B9jmsnews@200.27.221.71>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!nntp-server.pubsub.com!news1.nivel5.cl!news.vcd.cl!not-for-mailReferences:
<d8dd1c$ftv$1@helcaraxe.dcc.uchile.cl> <Xns9671D6AB8F28Bjmsnews@200.27.221.71> <d8dgt3$hnd$1@helcaraxe.dcc.uchile.cl>Show Full Headers
Complete Article Headers
X-Google-Thread: 1593cb,847abb2bff51d953
X-Google-Attributes: gid1593cb,public
X-Google-Language: ENGLISH,ASCII
Newsgroups: chile.comp.programacion
Subject: Re: consulta sql
From: "Jos� Miguel Santib��ez" <jms@nospam.nivel5.cl>
References: <d8dd1c$ftv$1@helcaraxe.dcc.uchile.cl> <Xns9671D6AB8F28Bjmsnews@200.27.221.71> <d8dgt3$hnd$1@helcaraxe.dcc.uchile.cl>
Organization: Caos Consultores
Message-ID: <Xns9671F176073B9jmsnews@200.27.221.71>
User-Agent: Xnews/5.04.25
X-Face: +|NgjgFM{<rs%\Q|vUu16]a6,}?MJTA<!PEEI+x&Gw-Gyq+?$}fvo+.(,-r;)~Qzn)#{{nxU,OT?w^s<7m4ckCJ*L$c#I)yHL7b)GdU*#l
NNTP-Posting-Host: 69-58-112.adsl.terra.cl
Date: 10 Jun 2005 23:50:06 -0400
X-Trace: news.vcd.cl!not-for-mail 1118458206 69-58-112.adsl.terra.cl (10 Jun 2005 23:50:06 -0400)
Lines: 24
X-Authenticated-User: jms
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!nntp-server.pubsub.com!news1.nivel5.cl!news.vcd.cl!not-for-mail