Helpful Year2000 Code

A new zip file has been added to the "Archives" section of the PL/SQL Pipeline - a free internet community for Oracle PL/SQL Development. The PL/SQL Pipeline is hosted by best-selling author Steven Feuerstein and sponsored by RevealNet. Enjoy!

• Fix Year 2000 Issues By Steven Feuerstein

When it comes to the Year 2000 bug, some of the thorniest problems for PL/SQL developers arise when you write or encounter code like this:

my_date := TO_DATE (my_string, 'MM/DD/YY');

In other words, you've got a hard-coded two-digit year number. This month's archive offers some techniques you can use to simultaneously avoid the two-digit year problem and also improve the string-date conversion capabilities of your systems.

This zip contains two files:

Year2k.doc - Word95 format article on dealing with Year 2000 issues within PL/SQL programs. Originally published in July 1997 SELECT Magazine.

datemgr.spp - Package that demonstrates how you can design a function to convert just about ANY string to a date, and bypass many Year 2000 problems. Format: pkzipped file, 27K.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 26 1998 - 08:03:35 CDT