My SQL challenge this morning required me to write a SQL select to select a date from a Timestamp field. I have started playing around with WDSC 7.0 Data perspective. I did not take to long to figure out, I am really digging SQL on the iSeries!
IVDTE is my Timestamp defined field in MIDINVPF.
where CHAR(DATE(ivdte), ISO) = '2012-04-12'
People who look through keyholes are apt to get the idea that most things are keyhole shaped. ~Author Unknown