Page 1 of 1
Date different in DB2
Posted: Mon Aug 16, 2004 5:58 am
by mandyli
What is data diff function in DB2 or Datastage?
Posted: Mon Aug 16, 2004 9:18 am
by vbeeram
Hi,
What exactly u want the Output in number of days OR in date format?
Posted: Mon Aug 16, 2004 9:48 pm
by mandyli
I want to find different no of days and no of month
Posted: Wed Aug 18, 2004 5:55 am
by lakshmipriya
For number of days u can use the juliandays function
convert both the dates for which u have to find the difference to juliandayfromdate
For number of months
use the function monthfromdate
Posted: Wed Aug 18, 2004 9:44 pm
by mandyli
Thanks I will try