I have a query where I pull a Julian date from a database: MYDATE
Then get TodaysDate using (current date)
SELECT MYDATE, (current date) As TodaysDate FROM LIBRARY.FILE
I need to get the difference of the two in days. How would I do it in my SELECT statement ?
I can convert the Julian date (MYDATE) to a date or a string that represents a date.....to be honest I am not sure what is being returned, but I use a Date Translation File to get it. My Date translation file has a FIELD TYPE of A.
It's obvious I am new to DB2. Please help a Newbie