I have 5 different tables that have a timestamp field call SysDate. What i want to do is combined them together but have run into an issue:
1. Four of the tables the timestamp field looks like 04/18/2018 10:30:32 AM
2. I have one the timestamp field looks like 04/18/2018 10:32
So it is missing the seconds and either the AM or PM. My question is can I use the makedate function to solve my issue. I would need to add either 00 to the seconds and then AM or PM. The other option I was looking at is trimming off the seconds and AM/PM from the four table that include it. I dont really want to do that. Any suggestions would be great.