How i can determine DBMS type using by arcgis server?

Question

I have layer with start time field

Timeslider filters displaying features of this layer, but query from layer returns all features independently of timeslider position

I'm add where condition to query (for example, start_date = '12.34.5678')

It works on one arcgis server, but don't on another

Reason is different database servers, that needs various date formats in query

How i can determine DBMS type for set necessary date format?

Or is there a way to get date format?

GeneralFailure · Answer

Thanks, but if i understood correctly, that solution is for desktop or server projects (reading local file with database configuration)

My project is web and written in javascript, i have no access to configuration files on server

Have layers or any other objects properties that contains info about database connection?

KishorGhatage · Answer

This KB article may help:

41112 - Extract server and database properties from layers in an MXD file

GeneralFailure · Answer

I applied workaround: several date formats for various dbms

All formats instead current are commented

But it's a crutch, and code editing is necessary when deploying project on customer's server