Up Prev Next
From: "Stevens, Nancy" <Nancy dot Stevens at LibertyMutual dot com>
Subject: RE: A question on Date
Date: Jul 31 1998 10:51AM
This is one way to get all rows with a date range in Sybase:
select * from pubs2..titles
where pubdate between "01-JAN-1995" and "01-JUL-1998"
> -----Original Message-----
> From: Brad Collins [SMTP:firstname.lastname@example.org]
> Sent: Thursday, July 30, 1998 9:32 PM
> To: SybPerl Discussion List
> Subject: A question on Date
> 'lo all,
> Got a silly date question.
> I'm trying to figure out an easy way to do queries of a range of
> Is there any way to get Sybase/Sybperl to convert getdate() or a
> field to UCT? Otherwise, is there an easy way to get all the rows
> with a
> datetime field between two given dates?
> Bare with me, I'm new at this :)
> Brad Collins