I have a beginner SQL question. I'm new to using SQL on the iseries. I want to get the system date and compare it to a date in a file and depending if its 30 days past delete that record. I can get most of it but the system date is driving me nuts. How do I get it and how can I convert the dates to compare then too. Also if anyone has a good reference on the web of good SQL tips and begginner stuff, that would be great. Remeber I'm a RPG programer not an SQL junkie yet. I like it so far. Very powerfull. Thanks in advance...
January 23, 2007 4:53 PM
June 20, 2008 6:30 PM