RSS Feed

Plugin Developer Discussion

Just wondering if I'm building a query if I can do Date truncation on columns/fields as to ignore the hours for example.

I tried TRUNC, ROUND, and FORMAT and all of these gave returned "Unknown function".

Just wondering.

Thanks.

===

System.ArgumentException: Unknown function: FORMAT

Server stack trace:
  at FogCreek.FogBugz.Database.CSqlParser.ParseFunction(CSqlTokenList tokens, Boolean fInsideSelect, Boolean fInsideInsert, Boolean fInsideOrderBy)
  at FogCreek.FogBugz.Database.CSqlParser.ParseTerm(CSqlTokenList tokens, Nullable`1 fInsideSelect, Nullable`1 fInsideInsert, Nullable`1 fInsideOrderBy)
  at FogCreek.FogBugz.Database.CSqlParser.ParseExpression(CSqlTokenList tokens, Nullable`1 fInsideSelect, Nullable`1 fInsideInsert, Nullable`1 fInsideOrderBy)
  at FogCreek.FogBugz.Database.CSqlParser.ParseBoolTerm(CSqlTokenList tokens)

Me speak good English (sometimes).

I meant "are there any standard date function supported in/for queries"?

Right now we only support functions that work identically across all our DMBSs (JET, MSSQL, MySQL).  I made a wiki page with the list:

https://developers.fogbugz.com/default.asp?W145