anchor.diff:  "
   
   "Functions (Time and Date)","TO_DATE","
  -TO_DATE( stringTerm [, formatString] )
  -","
  -Parses a string and returns a date.
  +TO_DATE( stringTerm [, formatString [, timeZoneIdString]] )
  +","
  +Parses a string and returns a date. Note that the
  +returned date is internally represented as the number
  +of milliseconds since the java epoch.
   The most important format characters are:
   y year, M month, d day, H hour, m minute, s second.
   The default format string is ""yyyy-MM-dd HH:mm:ss"".
   For details of the format, see ""java.text.SimpleDateFormat"".
  +By default, GMT will be used as the time zone when parsing the
  +date. However, a time zone id can also be supplied. This is
  +a time zone id such as 'GMT+1'. If 'local' is provided as the
  +time zone id, the local time zone will be used for parsing.
  +The configuration setting ""phoenix.query.dateFormatTimeZone""
  +can also be set to a time zone id, which will cause the
  +default of GMT to be overridden with the configured
  +time zone id. Please see the Data Type reference guide about
  +how Apache Phoenix presently defines the DATE datatype.
  +Additionally, Phoenix supports the ANSI SQL ""date"" literal which acts
  +similarly to the single-argument ""TO_DATE"" function.
   ","
   TO_DATE('Sat, 3 Feb 2001 03:05:06 GMT', 'EEE, d MMM yyyy HH:mm:ss z')
  +TO_DATE('1970-01-01', 'yyyy-MM-dd', 'GMT+1')
  +date "1970-01-01 12:30:00"
   "
   
   "Functions (Time and Date)","CURRENT_DATE","
  
positive.code: STDDEV_SAMP( X )
  "
  
  "Functions (Time and Date)","ROUND","
  ROUND(timestampTerm, {'DAY' | 'HOUR' | 'MINUTE' | 'SECOND' | 'MILLISECOND'} [, multiplierNumber])
  ","
  Rounds the timestamp to the nearest time unit specified. The multiplier is used to
  round to a multiple of a time unit (i.e. 10 minute) and defaults to 1 if not specified.
  This method returns a date.
  ","
  ROUND(date, 'MINUTE', 30)
  ROUND(time, 'HOUR')
  "
  
  "Functions (Time and Date)","TRUNCATE","
  TRUNC(timestampTerm, {'DAY' | 'HOUR' | 'MINUTE' | 'SECOND' | 'MILLISECOND'} [, multiplierInt])
  ","
  Truncates the timestamp to the next time unit closer to 0. The multiplier is used to
  truncate to a multiple of a time unit (i.e. 10 minute) and defaults to 1 if not specified.
  This method returns a date.
  ","
  TRUNCATE(timestamp, 'SECOND', 30)
  TRUNCATE(date, 'DAY', 7)
  "
  
  "Functions (String)","SUBSTR","
  
negative.code: ","
  The date data type. The format is yyyy-MM-dd hh:mm:ss, with both the date
  and time parts maintained to a millisecond accuracy. Mapped to ""java.sql.Date"".
  The binary representation is an 8 byte long (the number of milliseconds from the epoch), making it
  possible (although not necessarily recommended) to store more information within a DATE column than
  what is provided by ""java.sql.Date"". Note that the internal representation is based on a number
  of milliseconds since the epoch (which is based on a time in GMT), while ""java.sql.Date""
  will format dates based on the client's local time zone. Please note that this DATE type
  is different than the DATE type as defined by the SQL 92 standard in that it includes
  a time component. As such, it is not in compliance with the JDBC APIs. As the underlying data
  is still stored as a long, only the presentation of the value is incorrect.
  ","
  DATE
  "
  