MVSFORUMS.com

[prog_mario]

Hello, I need to perform the following query:

SELECT COUNT(*)
FROM TABLE
WHERE COLUMN >= CURRENT DATE - 6 MONTHS;

In this case COLUMN is a CHAR(8) formatted as YYYYMMDD.

Thanks.

[dbzTHEdinosauer]

char(date_expression,ISO)
ISO

[jim haire]

Untested:

[prog_mario]

Thanks a lot everybody. It worked.
_________________
The more I learn, the more I want to learn.

[dbzTHEdinosauer]

jim, you sql works,
but you are executing a multi-substring on the column for every row,
where as I attempted to only execute the scalar functions 1 time.
_________________
Dick Brenholtz
American living in Varel, Germany

[kolusu]

prog_mario,

Here is an alternative way to get the desired results. Untested SQL

[dbzTHEdinosauer]

Kolusu,

mind like a steel trap, you have!
_________________
Dick Brenholtz
American living in Varel, Germany