Time interval in seconds

[peppapig]

Have:

	START DATE	START TIME	END DATE	END TIME
ID01	12/7/2013	10:00:00	12/8/2013	10:00:00
ID02	12/7/2013	9:00:00	12/8/2013	9:00:00

Want:three more new variables START, END, Time interval from START to END in seconds

	START DATE	START TIME	START	END DATE	END TIME	END	Time Interval in Seconds
ID01	12/7/2013	10:00:00 AM	12/7/2013 10:00:00 AM	12/8/2013	13:00:00 pm	12/8/2013 13:00:00 pm	??
ID02	12/7/2013	9:00:00 AM	12/7/2013 9:00:00 AM	12/8/2013	16:00:00 PM	12/8/2013 16:00:00 pm	??

Thanks!

[PGStats · Accepted solution]

start = dhms(start_date,Hour(start_time), Minute(start_time), Second(start_time));

end = dhms(end_date,Hour(end_time), Minute(end_time), Second(end_time));

interval = intck("SECOND", start, end);

PG

[peppapig]

Thanks!

This is so quick and awesome.

It's working!!!

[data_null__]

I would skip all those extra functions as arguments to DHMS.

   s = dhms(sdate,0,0,stime);
   e = dhms(edate,0,0,etime);