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

[vhamberg@xxxxxxxxxxx]

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.