RE: - - Fechas

On Thu, 11 May 2006, Miguel Angel wrote:

> Yo sugiero esto:
>
> SELECT * FROM tabla WHERE EXTRACT(DAY FROM fecha)=EXTRACT(DAY FROM now())

Eso no funciona, ya que falta el mes:

SELECT * FROM tabla
WHERE EXTRACT(DAY FROM fecha) = EXTRACT(DAY FROM now())
AND EXTRACT(MONTH FROM fecha) = EXTRACT(MONTH FROM now())

Saludos... :-)

--
21:50:04 up 2 days, 9:07, 0 users, load average: 0.92, 0.37, 0.18
---------------------------------------------------------
Lic. Martín Marqués | SELECT 'mmarques' ||
Centro de Telemática | '@' || 'unl.edu.ar';
Universidad Nacional | DBA, Programador,
del Litoral | Administrador
---------------------------------------------------------