Is it possible to query temporal tables with "FOR SYSTEM_TIME?"
mdnpascual opened this issue · 1 comments
mdnpascual commented
I've been reading the docs and issues if anyone has tried using the query pattern FOR SYSTEM_TIME FROM <FromDate> TO <ToDate>
with no luck
An example query would be:
"SELECT * FROM [sampleTable] FOR SYSTEM_TIME FROM '{fromDate.ToString()}' TO '{toDate.ToString()}' WHERE [sampleColumn] = @p0"
mdnpascual commented
Figured out I can use FromRaw
and append the FOR SYSTEM_TIME FROM '{fromDate.ToString()}' TO '{toDate.ToString()}'
to convert it to a temporal query