Hi, I have a timestamp field in my talbe. I need to check its difference in days with the current date.
field name is time_stamp and I did it as follows: select age(timestamp '2000-06-28 15:39:47.272045') it gives me something like 6 years 11 mons 29 days 08:20:12.727955 How can i convert this result into absolute number of days. thanks, ~Jas