MS SQL Date functions

[harish_babu5]

Hi all,

I need to take data from two interfaces of MS SQL. Sender JDBC Communication channel.

In one, I have to take data from Jan 1st onwards till today. What date function can I use for that?

In another, I need to take data for two days each, Jan 1st and 2nd. Then Jan 3rd and 4th, like that. Here I have to change querry after executing each time. What function can I use here?

Regards

Harish Babu

[iaki_vila · Accepted solution]

Hi Harish,

You can use the SELECT XML format for JDBC: Defining a SELECT Statement - Advanced Adapter Engine - SAP Library

Also you can use the SELECT_QUERY and to work with the date format directly Defining an SQL_QUERY Statement - Advanced Adapter Engine - SAP Library, to work with dates: MS SQL Datetime convert examples

Personally i'd rather the first option and to change the date format with the DateTrans in the mapping.

Regards.

[harish_babu5 · Accepted solution]

Hi Inaki,

My requirement is for sender JDBC adapter and I have to place the query in the "Query SQL Statement"

Regards

Harish Babu