← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to drizzled/function/time/yearweek.h

  • Committer: Jay Pipes
  • Date: 2009-02-04 15:25:30 UTC
  • mto: This revision was merged to the branch mainline in revision 830.
  • Revision ID: jpipes@serialcoder-20090204152530-27x7k0vjx1pd3g3o
default_week_format variable has gone the way of the Dodo, as have the
WEEK() and YEARWEEK() functions.  These two functions, along with week_mode
(default_week_format) were inconsistent with standards and made redundant
by the DATE_FORMAT() function.

Cleaned up the former week_number_from_gregorian_date() function into
a simpler, strftime()-based solution in sync with PosgreSQL and SQL/ISO standards.

Clean up of the EXTRACT() function to use new temporal system and produce
proper errors on bad temporal values.

NOTE: Test cases for EXTRACT and cleanup of the func_time.test case have not
yet been committed.

Show diffs side-by-side

added added

removed removed

Lines of Context:
drizzled/function/time/yearweek.h
1
 
/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2
 
 *  vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
3
 
 *
4
 
 *  Copyright (C) 2008 Sun Microsystems
5
 
 *
6
 
 *  This program is free software; you can redistribute it and/or modify
7
 
 *  it under the terms of the GNU General Public License as published by
8
 
 *  the Free Software Foundation; version 2 of the License.
9
 
 *
10
 
 *  This program is distributed in the hope that it will be useful,
11
 
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
12
 
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
13
 
 *  GNU General Public License for more details.
14
 
 *
15
 
 *  You should have received a copy of the GNU General Public License
16
 
 *  along with this program; if not, write to the Free Software
17
 
 *  Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
18
 
 */
19
 
 
20
 
#ifndef DRIZZLED_FUNCTION_TIME_YEARWEEK_H
21
 
#define DRIZZLED_FUNCTION_TIME_YEARWEEK_H
22
 
 
23
 
#include <drizzled/function/math/int.h>
24
 
 
25
 
class Item_func_yearweek :public Item_int_func
26
 
{
27
 
public:
28
 
  Item_func_yearweek(Item *a,Item *b) :Item_int_func(a,b) {}
29
 
  int64_t val_int();
30
 
  const char *func_name() const { return "yearweek"; }
31
 
  void fix_length_and_dec()
32
 
  {
33
 
    decimals=0;
34
 
    max_length=6*MY_CHARSET_BIN_MB_MAXLEN;
35
 
    maybe_null=1;
36
 
  }
37
 
};
38
 
 
39
 
#endif /* DRIZZLED_FUNCTION_TIME_YEARWEEK_H */