| Win95 Client Issue? [message #367660] |
Tue, 24 August 1999 13:38  |
Dave
Messages: 92
Registered: August 1999
|
Member |
|
|
When the following query is run, on a Win95 client, with the year defined as 1999 a row is returned. Change the year to 2000 and no row is returned.
SELECT lpad(period,2,0),
year
FROM rpts.snap_edfiglperiod
WHERE compno = '1'
AND( to_date('01/01/1999', 'MM/DD/YYYY') >= TO_DATE(periodstartdate)
AND to_date('01/01/1999', 'MM/DD/YYYY') <= TO_DATE(PERIODENDDATE) )
AND period 13
Run the same query on our HP 1020 where the DB is and a row is returned (for year 2000).
Has anyone run into this type of behavior? If so, what is the cause/workaround?
TIA
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
