RE: Using GREATEST with DATETIME/TIMESTAMP values

2004-03-08 Thread Lance Lovette
be the documentation could clarify this point. > -Original Message- > From: Egor Egorov [mailto:[EMAIL PROTECTED] > Sent: Monday, March 08, 2004 4:39 AM > To: [EMAIL PROTECTED] > Subject: Re: Using GREATEST with DATETIME/TIMESTAMP values > > You shouldn't per

Re: Using GREATEST with DATETIME/TIMESTAMP values

2004-03-08 Thread Egor Egorov
"Lance Lovette" <[EMAIL PROTECTED]> wrote: > What is the best or most efficient way to compare a mix of DATETIME and > TIMESTAMP values using GREATEST()? Some values are columns and some are > literals. Should I convert TIMESTAMP values to DATETIME formatted strings > using DATE_FORMAT or convert e