So it would seem that while there are numerous functions to extract parts of a
timestamp into it’s component parts, there is no function to create a date from
a piece of text, no date operators nor any date functions by which you can add
or subtract days or other component parts of a time
the error message seems to be in line with what is explain in the documentation:
> Automatic data type conversion is implemented between numeric types.
> A string that represents a number is not converted to a corresponding number.
> There are special CAST functions that will convert values from
What kind of date math does 4D’s SQL support? The following gives an error
where I’m trying to subtract 2 days from the date:
Select someDate - 2
From someTable
The error returned is “Operation VK_TIME - VK_LONG8 is not type safe. Failed to
validate SELECT command.”
Same thing if you put that
3 matches
Mail list logo