Hi all
We would like to use DB function when inserting or receiving dolumns
i.e. fn:FORMAT(GETDATE(),'yyyyMMdd'), or use TRIM, SUBSTRING, ... or whatever is available by the Database.
POST http://localhost:8080/v1/rdbms/db/users HTTP/1.1
content-type: application/json
{
"first_name": "XXXXX",
"last_name": "YYYY",
"email": "XXXXXX@gmail.com",
"phone": "+491234567890",
"is_active": 1,
"test_date": "fn:FORMAT(GETDATE(),'yyyyMMdd')"
}
Or even Combined Function calls like
fn:UPPER(TRIM( <column_name>))
Thanks