Re: No rows? SQR lets me down.

[Barbara Wood <BARBARA_WOOD@NON-HP-PALOALTO-OM13.OM.HP.COM>]

     Hi Chris,

     SQR only knows about one native date format.  Is your native date
     format 'MON_DD_YYYY'?  If so, this is the format you should use.
     However, if you want to display/input dates in a different format
     without having to convert, then you will need to reset in your SQR
     program the native date format.  You do this in the BEGIN-SETUP
     section of your SQR.

          Begin-Setup

          alter session set nls_date_format = 'mm/dd/yyyy'

          End-Setup

     -Barb


______________________________ Reply Separator _________________________________
Subject: Re: No rows? SQR lets me down.
Author:  Non-HP-cwanko (cwanko@GRENET.ATT.COM) at HP-PaloAlto,mimegw9
Date:    5/5/98 6:33 AM


> If your date format is correct, your dates should include the
preceding
> zeros...you write
> AND wo6 >= '1/1/1998'
> and wo6 <  '5/1/1998'
>  and perhaps should've written
> AND wo6 >= '01/01/1998'
> and wo6 <  '05/01/1998'

The date format is correct, as I entered it.  I'm using Sybase 11.0.3,
connected to a Win95 client
using the Client Libraries supplied by Sybase.  SQL/Talk runs this query
just fine.  isql on the
server runs this query just fine.  Only SQR fails to return rows, so
what is it about the SQR
that isn't like standard SQL?

By the way, LIKE is the same as EQUALS if the percent-sign is omitted,
at least in the Sybase
context.  That's not the broken piece.  Also, Sybase, at least in past
experiences, can handle
all of these:
                        1/1/1998
                        Jan 1 1998
                        Jan 1, 1998
                        1-1-1998
                        01/01/98
                        January 1 1998

Or is it a bug?  Or is my machine loopy?

-Chris