RE: sql select on timestamp field

One thing to note that if you have an index on the timestamp field, then with 
both of Brigitta methods the index will _NOT_ be used.

If you have an index on the field, use Peter's method.

If you don't have an index, then it doesn't matter much but Peter's is still 
less work as no conversions are required.

No offense intended Brigitta, for small data sets I'll often use methods like 
yours that convert the fields I'm searching on.

HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Hauser, Birgitta
> Sent: Wednesday, August 17, 2005 8:32 AM
> To: 'Midrange Systems Technical Discussion'
> Subject: AW: sql select on timestamp field
> 
> 
> An other way would be:
> Select * 
>   From logivdtl
>   Where Char(IVTMST) like '2005-08-12%'
> 
> Birgitta 
>