Re: SQR and null dates

[Pamela Lantzy <PLantzy@UAMAIL.ALBANY.EDU>]

In SQL Plus format the date in the select statement, you may only be getting
a partial date.

select to_char(field, 'MM/DD/YYYY') from <table>

To see if that's the actual date. because SQLPlus sometimes truncates what
is return.



 -----Original Message-----
From:   Jonathan Sprenke [mailto:jsprenke@AMAZON.COM]
Sent:   Wednesday, June 27, 2001 2:54 PM
To:     SQR-USERS@LIST.IEX.NET
Subject:        SQR and null dates

SQR 6.0.4
Sun solaris
peoplesoft 8 sp1
peopletools 8.13
oracle 8.1.6

We are running sqr programs that grab a date from one table and update it on
another table. When null dates are grabbed and inserted and i go look at the
result in sql plus i see that '00-DECEMB' has been inserted or a crazy
random date which in YYYYMMDD format comes out looking like 9902/10/03 is
inserted. When i do the same operation sqlplus using sql i do not get this
result. Does anyone have any suggestions?