[no subject]

[Albert Howard <starbukk@HOTMAIL.COM>]

With that hire date, your installation is apparently set up for a two
digit year format, which it why it is returned like that.  The date
conversion routines work with whatever the installation parameters are
set for.  You cant change the $Year4 parm without changing the
installation date parameters.  To get the four digit year, you will need
to either change your installation parms AND the setenv.sqc variables to
match, or force the date into four-digit mode using the TO_DATE
function.  Try

TO_DATE(A.HIRE_DT,'YYYY-MM-DD') &hire_dt

for the sql that gets the date.  That should do it.

>Date:         Thu, 11 Jun 1998 14:53:51 -0400
>Reply-To: SQR-USERS@USA.NET
>From: "Williams, Kara" <KWilliams@CAROLINAS.ORG>
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>
>This is specifically for PeopleSoft Users:
>Here's a problem I've come across...any suggestions?
>(We are running this in Oracle 8.0)
>My variable $hire_dt formats with a two digit year:  07-JUN-89
>I am trying to convert this date using the Convert-To-DTU-Date sqc so
>that the new format reads YYYY-MM-DD.
>The program is returning YY-MM-DD.
>The description of the Convert-To-DTU-Date procedure indicates that the
>output will give YYYY (a 4 digit year).
>Thanks for any help/suggestions.
>


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com