Unified SQL - date functions

[chkaufmann]

Hi,

I need unified sql for the function "day of the year". In MS SQL Server this is for example

datepart(dayofyear, BIRTHDATE)

Is this available? If not, could this be added, maybe myself?

cu ck

[azyk]

We are investigating a possibility to add the datepart function in Unified SQL and will inform you about the results.

[chkaufmann]

Hi,

I think the datepart function is still missing. Any news here?

Then I still need MS Access as option in one project and there is no SQL function "upper", it's named "ucase".

Can I just extend the definition for upper in all initalization sections? Like this?

AccessFunctions.Add('UPPER', 'UCASE(%s)');

And could you add that in the next update?

Thanks

Regards
Christian

[MaximG]

We added support of UPPER and LOWER functions to be used with Unified SQL. The required changes will be available in the next versions of our product, the release of which is planned shortly. The DEPART function you are interested in is directly absent in many databases that UniDAC supports. Therefore, its implementation is missing when using Unified SQL.
Perhaps in the future versions of our product, we will independently implement similar functionality for using with all the supported ones, however, we cannot name the deadlines of the work on this implementation. Currently, you can try implementing the behavior you are interested in by yourself, similar to the provided sample.