List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:September 17 1999 10:49pm
Subject:Re: EXTRACT() function?
View as plain text  
>>>>> "James" == James Manning <jmm@stripped> writes:

James> [ Thursday, September 16, 1999 ] Martin Ramsch wrote:
>> MySQL Reference Manual,
>> chapter "7.3.11 Date and time functions",
>> description of "DATE_ADD"
>> some of the examples use a function EXTRACT.
>> Does this function really exist in some version of MySQL?
>> It's not mentioned somewhere else in the manual ...

James> section D.1.4 says it was added in 3.23.0 as an ODBC 3.0 function,
James> although the link provided only points to the section you saw:

James> "The EXTRACT() function returns the corresponding interval from the date."

James> Not very helpful at all :)

I have now changed the above to:

The EXTRACT(type FROM date) function returns the 'type' interval from the date.

Hope this helps.

EXTRACT() function?Martin Ramsch16 Sep
  • Re: EXTRACT() function?James Manning17 Sep
    • Re: EXTRACT() function?Michael Widenius18 Sep