I have a field on a DB2 database that has the date and time a field was created in the following format:
for example, for may 9th 2006 at 2:43:23 PM the field has something like
20060509144323 (note 2 pm is changed by 14, to european format).
I need to know for each field the time difference in seconds comparing with the current date and time - now() -
How can I do that?!