Re: Force four-digit year?

Yosi Greenfield <yosi_at_newsalert.com> wrote:

>Anyone know of a way to force the user to enter four-digit year for
>implicit conversions? Setting NLS_DATE_FORMAT will cause the database to
>allow four digits, and depending if you use RRRR oe YYYY will set it to
>something or other.
>
>But you can still enter a two-digit year using implicit conversions
>(without to_date). Oracle will then set the century to 00 (for YY) or 19
>or 20 (for RR).
>
>Support said you can't force a four digit year. They kindly suggested I
>write triggers on all my date fields. Thank you Support.
>
>Any better ideas? For lack of anything else, I'll end up with RRRR and
>some stern memos to our developers. But I'd rather force the developers
>to do something they'd rather not do - you know, code properly.
>
>Thanks,
>
>Yosi
>

The only place you can force that format is in Forms applications....you can set the field format to FXDD-MON-YYYY and users must match that format exactly ( hence the FX, force exact ) in order to enter data...

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Wed Aug 25 1999 - 16:00:41 CDT