So I've gone a few steps further with the and query combination, but it's very granular.
I renamed the script as GetDateTime and declared the function as GetDateTime
DATETIME AS SCRIPT [GetDateTime] ENTRY 'Script.Now';
Wrote a new SQL Query that uses the VALUES statement:
The result provides each of the elements of the DateTime string in a separate column.
How would I combine the statements to give a date and time in a separate column?
Example 2018-2-10 and 16:50 with column titles Date and Time respectively?
Is there any way to make the query more efficient?
This query takes about a 1 second to run. I presume it's calling the system time repeatedly
Could I make it be faster?
On a separate note, what can I use to format any code snippets I share so the snippets look like the code shared by the Manifold team?