Re: Proposal for two (or more) new time and date functions

2001-11-29 Thread Michael Widenius
Hi! > "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes: Jeremy> On Wed, Nov 28, 2001 at 01:30:42PM -0800, [EMAIL PROTECTED] wrote: >> >> I think while you've got the hood up, a better method of doing the >> difference between two dates should be derived. >> >> Unless I'm going about

RE: Proposal for two (or more) new time and date functions

2001-11-28 Thread Alok K. Dhir
ay, November 28, 2001 3:50 PM > To: [EMAIL PROTECTED] > Subject: Re: Proposal for two (or more) new time and date functions > > > > I think while you've got the hood up, a better method of > doing the difference between two dates should be derived. > > Unless I&#x

Re: Proposal for two (or more) new time and date functions

2001-11-28 Thread btjones
I think while you've got the hood up, a better method of doing the difference between two dates should be derived. Unless I'm going about this all wrong, the only way to get the time difference between two values currently is: UNIX_TIMESTAMP(end_datetime) - UNIX_TIMESTAMP(start_datetime)