Server crash when trying convert timestamp to string with incorrect format

Sherzod Mutalov shmutalov at gmail.com
Thu Oct 1 15:30:46 CEST 2015


Hello Developers,
      MonetDB  server  crashes when trying to execute timestamp_to_str
  function with incorrect format string.

  SQL:
  SELECT timestamp_to_str(current_timestamp, '%Q');

  I send bug report,
  https://www.monetdb.org/bugzilla/show_bug.cgi?id=3816
  
  But, also I need QUARTER extraction from date values by SQL server,
  like "extract(quarter from date '2015-10-01')" = 4
  Now, I am using this "((extract(month from {0}) - 1) / 3 + 1)"
-- 
Best regards,
 Sherzod                          mailto:shmutalov at gmail.com



More information about the developers-list mailing list