Azure-cosmos-dotnet-v3: Date and time functions support

[lbicknese]

The current v3 SDK does not support all date and time functions. The following functions are not supported:

• GetCurrentTicks
• DateTimePart
• DateTimeToTicks
• TicksToDateTime

I receive the following error(s) when running the sample queries provided in the links above:

Exception thrown: 'Microsoft.Azure.Cosmos.CosmosException' in System.Private.CoreLib.dll: 'Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: ; Reason: (Microsoft.Azure.Cosmos.Query.Core.Monads.ExceptionWithStackTraceException: TryCatch resulted in an exception. ---> Microsoft.Azure.Cosmos.Query.Core.Monads.ExceptionWithStackTraceException: TryCatch resulted in an exception. ---> Microsoft.Azure.Cosmos.Query.Core.Exceptions.ExpectedQueryPartitionProviderException: {"errors":[{"severity":"Error","location":{"start":7,"end":22},"code":"SC2005","message":"'GetCurrentTicks' is not a recognized built-in function name."}]}

I would like the SDK to be updated to support these methods.

Currently, I am using string functions to manipulate dates. This is less than ideal, and would prefer to use the date and time functions. I am able to run the queries with these methods through Data Explorer. I have tested on versions 3.12.0 and 3.13.0-preview.

[timsander1]

@j82w these new system functions were released back in July (0701 train). What's the timeline for the next SDK release that will support them?

[william-liebenberg]

Hi @j82w

Just tried the 3.13.0-preview release and none of the mentioned date functions from the OP work.

Is there another release coming for that?

Thanks

[j82w]

The release is planned for next week.

[j82w]

@william-liebenberg and @lbicknese please try 3.13.0

[william-liebenberg]

Hi @j82w

Confirmed :) its working nicely.

Thanks.