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 kind of date expression in the Where clause.  The 
manual is silent on date math as far as I can tell.

------------------------------------------------
Richard Wright
DataDomain
[email protected]
------------------------------------------------

**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[email protected]
**********************************************************************

Reply via email to