I want to display the server time on the screen of each client. Using a Client tag, I can set its Datatype to DateTime and use
SELECT NOW()to return the time from the server, formatting it using the Metadata Format property. However, if I try to do the same using a SQLTag DB tag, the tag fails with an EXPRESSION_EVAL_ERROR.
Is there any reason I can’t use a DB tag to do this? Is there any difference in using a Client tag versus a DB tag? (I thought using a DB tag would mean the database was only queried once each scan interval and the results passed to every client, rather than each client issuing its own query to the database.)