Hello all,
(on Universe, with UVODBC connector)
One bottle in the see !
How to create a odbc sql queries with WHERE clause test DATEFIELD with
subqueries DATE result value.
exemple :
I have a generic table where I define "CALENDAR" values from DATE()
computing
SELECT * FROM CALENDAR;
ID.............. DATES
TODAY........... 16 JUN 2006
TOMORROW........ 17 JUN 2006
YESTERDAY....... 15 JUN 2006
CURRENTYEAR..... 2006
PREVIOUSYEAR.... 2005
CURRENTMONTH.... 06
PREVIOUSMONTH... 05
DAYOFWEEK....... 5
CURRENTQUARTER.. 2
PREVIOUSQUARTER. 1
NEXTQUARTER..... 3
etc...
From SQL stmt I want to Select all record where datefield check TODAY, I
write like this :
SELECT MYDATEFIELD FROM MYTABLE WHERE MYTABLE.MYDATEFIELD operator (SELECT
TODAY FROM CALENDAR);
with =, <=, >= operators the system reply nothing found !
with IN operator, the system found all record "=" TODAY
All idea are welcome to test greather/less than today... .
Thanks
Manu
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
