Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: date case sensitive?
On Thu, 18 Oct 2001 11:04:25 GMT, Steve .
<syarbrou_at_nospam.enteract.com> wrote:
>If I do a where clause on a search, and compare a date in a database
>to say 23-MAR-01, or 23-mar-01, or 23-Mar-01, will they return
>different results depending on case? Trying to figure out if it's
>necessary to add in there a UPPER function since the date is user
>inserted. Thanks.
>
>Steve
>
>newsgroup replies preferred. Remove nospam when replying thru email.
No
Hth
Sybrand Bakker, Senior Oracle DBA Received on Thu Oct 18 2001 - 13:23:00 CDT
![]() |
![]() |