RE: Using a TIMESTAMP field in a WHERE CLAUSE....

["Graap, Kenneth" <keg@xxxxxxxxxxxxx>]

That did it!  

Thanx Vern

Kenneth
Kenneth E. Graap
 
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
vhamberg@xxxxxxxxxxx
Sent: Tuesday, April 01, 2008 3:55 PM
To: Midrange Systems Technical Discussion
Subject: Re: Using a TIMESTAMP field in a WHERE CLAUSE....

kenneth

I often use something like

where date(timstp) between '2008-01-01' and '2008-12-31'

That simplifies it - but you can also use the full timestamp

where timstp between '2008-01-01-00.00.00.000000' and
'2008-01-31-23.59.59.999999'

I suspect the second would perform a little better - don't know how
much.

Goin' to the Grand Ole Opry!! 

Vern

-------------- Original message -------------- 
From: "Graap, Kenneth" <keg@xxxxxxxxxxxxx> 

> I'm trying to select records from a file on my System i using the 
> iSeries Navigator Data Transfer feature ... This file contains a field

> that has a type of TIMESTAMP. 
>
>
>
> I'm having trouble building the WHERE clause in my SELECT statement. 
>
>
>
> I want to select all the records between two dates based on the values

> in this TIMESTAMP field 
>
>
>
> Could anyone provide me with an example? 
>
>
>
> Kenneth 
>
> Kenneth E. Graap 
>
> Systems Administrator 
>
> NW Natural 
>
> keg@xxxxxxxxxxxxx 
>
> 503-226-4211 x5537 
>
>
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/midrange-l.