Member Avatar for andydeans

hi,

i want to add an end time in my query using my time to call column.

at the moment i have a time to call which will be the start time however i want to add timetocall as endtime which is 15 mins after the timetocall column.

i am syncing this to outlook that is why i need the two and at moment it is not possible to add another column to the existing database.

here is my query:

SELECT tasks.TaskID, tasks.TaskAdded, tasks.TaskType, tasks.Urgent, tasks.clients_ClientID, tasks.TaskTitle, tasks.ProductAssociated, tasks.TaskDescription, tasks.FurtherAction, tasks.Documents_DocID, tasks.Tasks_UserID, tasks.Task_AddedByUserID, tasks.TaskDueDate, tasks.TimeToCall, tasks.Completed, users.UserID, users.FullName, clients.ClientID, clients.App1FirstName, clients.App1LastName, clients.ClientUserID
FROM tasks JOIN users on Tasks_UserID = users.UserID LEFT JOIN clients ON tasks.clients_ClientID = clients.ClientID

not sure how to ADDTIME() to the timetocall and use this as an alias of "EndTimeToCall" ??

any help appreciated.

many thanks

  • 2 Contributors
  • 2 Replies
  • 178 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by andydeans
Member Avatar for andydeans

thansk for the help that sorted it.

had to take the s off minutes to make it MINUTE

thanks again

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.