How to use sql functions like SYSUTCDATETIME() with OrmLite

ServiceStack.OrmLite
1

I would like to update some fields in the table with sql’s system functions.

For example:
I would like to update some date field in the table with sql’s function “SYSUTCDATETIME()” by using OrmLite programatically (without providing SQL text).

I need a solution which works for different database providers at the same time. Is this possible?

Regards, Marko

2

We just added a feature to set default column values to use the RDBMS System UTC time in this commit.

It works by having each Dialect maintain a variable placeholder for special constants like {SYSTEM_UTC}

You can look at this test for a usage example. It’s only available from v4.0.47 that’s on MyGet.