Hello, does anyone here know if we can use commands like LAST_DAY() or EXTRACT() etc in OAS DV?

Question

Hello, does anyone here know if we can use commands like LAST_DAY() or EXTRACT() etc in OAS DV? I would like to create a dataset from a MSSQL database in OAS DV by using the manual query but I always get error pop up saying unexpected error or syntax not invalid logical sql statements. Thank you!

Ram-Oracle · Accepted Answer

Hi @User_B6HPR ,Please check the screenshots below to use last_day ,extract month in the dataset.

last_day:

output:

extract month:

output:

The datasource for the above test case is ORACLE.

As these functions are db functions ,for mssql database you may need to use equivalent functions related to  last day and extract function.