You can translate the question and the replies:

Denodo query

Hi All, I want to a query which return the salary of emp for lastmonthof day from the given below query. Ex: Select * from emp where p_emp_id=1 and p_doj='3/10/2023. Here p_doj is a parameter and emp is a derived view. I need data like this sal for parameter date(3/10/2023) and sal for lastmonthofday(3/31/2023). thanks
user
27-03-2023 13:02:48 -0400
code

1 Answer

Hi, I’d check[ the Datetime functions section](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/datetime_functions/datetime_functions) of the VDP VQL Guide, where you can check the datetime functions. I’d consider the [LASTDAYOFMONTH](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/datetime_functions/datetime_functions#lastdayofmonth) function that returns the datetime passed as a parameter with the field day rolled up to the last day of the month. Hope this helps!
Denodo Team
29-03-2023 08:06:36 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here