Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
get current month and current year data from DB2 table
Hello. Please help as this is urgent. I have a DB2 table where I need to get the current month and year from table X. gl_date is defined as date and is 10 bytes. Here is the query I used. It works if I use the month or the year but not both. Thank you. select * from table x where...
