on 10-20-2007 7:37 AM
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!
Hi Erick ,
+ ¿Is this posible in XI?...+
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.