|
Great, thanks Rob. Brian. -----Original Message----- From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx] Sent: Thursday, January 12, 2006 5:02 PM To: Midrange Systems Technical Discussion Subject: Re: Tracing iSeries SQL Queries from a web page Maybe the STRSQL and your web connection use different job date formats and that is why it works differently. Can you change and char(krdate)='12/23/06' to and krdate=date('2006-12-23') For future reference, always pick a day greater than 12 so that we can make sure that we format it right. And not have to think "did he mean mm/dd/yy or dd/mm/yy?". Rob Berendt
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.