sybperl-l Archive

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:bradc@micromuse.com]
> 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
> dates.
> Is there any way to get Sybase/Sybperl to convert getdate() or a
> datetime
> 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
> Micromuse