Timestamp question

GertV

I'm trying to create the following:

CREATE EmployeesCalendar FOR EACH DAY BETWEEN EmployeesOnJobs.Startdate AND EmployeesOnJobs.Enddate WITH EmployeesCalendar.StartTime=DAY

This gives me the correct Date in the Starttime but the time is set to 00:00. I need to add the time from the Starttime field in EmployeesOnJob. I have tried many ways but can't find one that works.

Anyone knows how to do this?

aware_support

There are many date functions that you can use. Just subtracting two timestamps gives you number of hours difference.