Re: compare against date field (in multination app)

In article <33oips4vvq8aa9i0u2muca7q0qv2ormvit_at_4ax.com>,   Bernd Rosenau <brosenau_at_gss-online.de> wrote:
> Hello,
>
> my app written in VB 6 uses Oracle 8 as backend.
> I need to compare against date field.
>
> How can i do this ? It needs to work with different date formats, e.g.
> the german format dd.mm.yyyy or the french dd/mm/yyyy or the american
> mm/dd/yyyy.
>
> Many thanks in advance for your help,
>
> Regards, Bernd
>
>

select value
from nls_session_parameters
where parameter = 'NLS_DATE_FORMAT'
/
will retrieve the mask the end-user is applying.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.