RE: DATES & Optimization

2002-01-11 Thread Robert L. Yelvington
Thanks, Paul. ;) ~rob > -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 09, 2002 8:22 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: DATES & Optimization > > > At 9:02 -0600 1/9/02, Robert L. Yelvin

Re: DATES & Optimization

2002-01-09 Thread Paul DuBois
At 20:22 -0600 1/9/02, Paul DuBois wrote: >At 9:02 -0600 1/9/02, Robert L. Yelvington wrote: >>Two quick qux for the gurus on the list! >> >>1. If I needed to do date calculations based upon a TIME STAMP field, what's >>the most efficient way to accomplish this with respect to data types (field >>

Re: DATES & Optimization

2002-01-09 Thread Paul DuBois
At 9:02 -0600 1/9/02, Robert L. Yelvington wrote: >Two quick qux for the gurus on the list! > >1. If I needed to do date calculations based upon a TIME STAMP field, what's >the most efficient way to accomplish this with respect to data types (field >types...I already understand how to use the DATE

DATES & Optimization

2002-01-09 Thread Robert L. Yelvington
Two quick qux for the gurus on the list! 1. If I needed to do date calculations based upon a TIME STAMP field, what's the most efficient way to accomplish this with respect to data types (field types...I already understand how to use the DATE functions and am aware of locale time and UNIX time tr