cancel
Showing results for 
Search instead for 
Did you mean: 

u00BFA sql stament with a date in it can be dynamic?

Former Member
0 Kudos

Hi all

I need to have in a SQL stament a SELECT with the date minus one day, is something like this

SELECT ALL FROM TABLE WHERE DATE-1.

¿Is this posible in XI?...

The JDBC is conecting with a Progress database...

Thaks!

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member189387
Active Contributor
0 Kudos

Hi Erick ,

+ ¿Is this posible in XI?...+



Yes. It is possible. Are you using the JDBC Sender ? You can write Query Staement as

+


SELECT * FROM TABLE WHERE (TDate= ( GETDATE() - 1 ) )

+

from the above TDate is one column which contains the required date

      • Assign points if you found helpful

Regards.,

V.Rangarajan

Message was edited by:

ranga rajan

Former Member
0 Kudos

Hi

The function GETDATE is in progress? Someone tell me that this funtion were only for Microsoft SQL Server...

Thanks

former_member189387
Active Contributor
0 Kudos

Hi ,

Yes. It depends on the database . This example for MS SQL Server .

Regards.,

V.Rangarajan

Former Member
0 Kudos

I was thinking that the solution could be a store procedure that makes a file with data from the database, but i dont know is there is another solution....