hi all

I have table with data inside

calving date
---- ------------

10-jan-2001
11-feb-2002
08-jan-2003




I'm looking for querry which will return

calving date inter calving period in day
---- ------------ ---------------------------

10-jan-2001 0
11-jan-2002 366
10-jan-2003 365


Thanks & Regards,
Harik




Oracle LazyDBA home page