Skip to content

Support of using Database function when inserting / receiving dolumns i.e. GETDATE() #911

@cloud4every1

Description

@cloud4every1

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": "[email protected]",
    "phone": "+491234567890",
    "is_active": 1,
    "test_date":  "fn:FORMAT(GETDATE(),'yyyyMMdd')"
}

Or even Combined Function calls like

fn:UPPER(TRIM( <column_name>))

Thanks

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions