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

Home -> Community -> Usenet -> c.d.o.misc -> Re: date format in SQL query

Re: date format in SQL query

From: Wesley <www_dba_at_yahoo.com.hk>
Date: Wed, 01 Dec 1999 03:05:15 GMT
Message-ID: <822399$h5k$1@nnrp1.deja.com>


Hi,

Try BETWEEN '01-OCT-99' and '30-OCT-99'

This will depend on your default date format.

HTH. Wesley.

In article <821m66$80l$1_at_nnrp1.deja.com>,   nmadson_at_my-deja.com wrote:
> I got the following query to work, but I wonder if there isn't an
> easier way? In MS Access I would be able to just say 'BETWEEN
> #10/1/99# and #10/30/99#'. Is there some sort of comparable syntax in
> Oracle?
>
> select a.SOURCE_AU, Count(a.DEPOSIT_UISN) as NumDeposits
> from T_DW_SOW_DEPOSITS a
> where a.PROCESS_DATE
> between
> TRUNC(TO_DATE('10011999', 'MMDDYYYY')) and TRUNC(TO_DATE
> ('10301999', 'MMDDYYYY'))
> group by a.SOURCE_AU
>
> TIA,
> Nolan Madson
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 30 1999 - 21:05:15 CST

Original text of this message

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