Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle Date Functions

Oracle Date Functions

From: Art Vandolay <avandolay_at_hotmail.com>
Date: Sun, 25 Apr 1999 04:50:34 GMT
Message-ID: <37229e7d.81660050@nntp.ix.netcom.com>


Greetings All,

I'm trying to compare a date contained in a DATE_START field with the interal CURRENT_DATE. It's been a while since I did any SQL programming w/out a GUI, and I need help on the format of making the CURRENT_DATE call.

This is the bogus code I'm using now:

SELECT * FROM RESPBLTY
WHERE DATE_START <= CURRENT_DATE;

Thanks in advance!

Received on Sat Apr 24 1999 - 23:50:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US