Page 1 of 1

working with dates

Posted: Thu Oct 08, 2015 11:45 am
by sucharita14
hello,
I have an issue. I embedded db2 query in an easytrieve program. The program is running currectly but when I am trying to check whether enddate is greater than current date in the where clause, it is throwing an -401 sqlcode error. The format of date in my table is dd.mm.yyyy
and the query which I wrote is where enddate>sysdate. And I assume that sysdate is in the format dd/mm/yyyy. What should I write in where clause then,
Can anyone please help me through this?