Re: date case sensitive?

From: Andreas Stephan <as.stedat_at_gmx.net>
Date: Thu, 18 Oct 2001 14:04:48 +0200
Message-ID: <9qmgdr$oev9@byz672.bayer-ag.com>

Hi Steve,

if using date values in where clauses use

where date_field = to_date('01-JAN-2001','DD-MON-YYYY') or any other valid date format string
eg
where date_field = to_date(date_string,'YYYY/MM/YY') if the string is constructed as '2002/09/23'

This will prevent you from problems arising with different NLS_LANG values.

hth
Andy

"Steve ." <syarbrou_at_nospam.enteract.com> schrieb im Newsbeitrag news:5mdtstsoal2b41gb29q80fnve38cj9lenn_at_4ax.com...
> 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.
Received on Thu Oct 18 2001 - 07:04:48 CDT