Re: Peoplesoft, SQR, and Date/Time formatting

[Albert Howard <starbukk@HOTMAIL.COM>]

The closest you can come to platform independence will be to use
conditional compilation, i.e #ifdef:

#ifdef ORACLE
  to_date($datefield),
#else
  $datefield,
#endif


>Date:         Tue, 19 May 1998 09:34:34 -0700
>Reply-To: SQR-USERS@USA.NET
>From: "Walcker, Paul" <pwalcker@ISD.CO.SAN-BERNARDINO.CA.US>
>Subject:      Peoplesoft, SQR, and Date/Time formatting
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>
>Sorry to re-hash this subject.  All of the date/time solutions that I
>have been reading have been very helpful, but my tech lead wants
>solutions to database problems that are platform independent.  We are
>currently using Peoplesoft 7, SQR 3, and Oracle 7.3.
>
>I am having the following problems that I would have expected the
>peoplesoft datetime.sqc to have solved. Am I missing something?
>
>1.  When referencing a timestamp field in my SQL, I pass the timestamp
>through their Format-DateTime procedure.
>
>do Format-DateTime('05/18/1998 16:37:58', $out, {DEFMDY}, 'time',
>'native')
>
>This function returns '18-MAY-1998 4:37:58 PM'.  When I include this
>returned value in my SQL, Oracle gives me the error ORA-01830: date
>format picture ends before converting entire input string.  Of course
>when I use the Oracle to_date function to convert this in the SQL I
have
>no problems, but now the SQL is platform dependent.
>
>
>2.  Some of the peoplesoft fields are set up as timestamp fields, but I
>only have a date to pass to the field (PS_TL_RAPID_DLY.DATE_UNDER_RPT).
>Once again, I call Format-DateTime
>
>do Format-DateTime('05/18/1998', $out, {DEFMDY}, 'time', 'native')
>
>This function returns '18-MAY-1998 12:05:18 AM'.  I would have expected
>to receive '18-MAY-1998 00:00:00 AM'.  The month and day consistently
>appear as the minute and second of the modified field.  The hour seems
>to fluctuate depending on the time of day the sqc is called.
>
>
>What am I doing wrong here?
>
>
>Thanks for your input
>
>Paul
>


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