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

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.