Kbase P11896: What is the proper SQL92 syntax to compare a field to the la
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/27/2003 |
|
Status: Unverified
GOAL:
What is the proper SQL92 syntax to compare a field to the last two digits of the current year in a SELECT statement?
FACT(s) (Environment):
Progress 9.1x
FIX:
SELECT * FROM PUB.SomeTable WHERE SUBSTRING(SomeField,1,2) = TO_CHAR(CURDATE(),'YY')