3 Replies Latest reply: Oct 2, 2018 4:03 AM by Ruan Greeff RSS

    TimeStamp Field Question

    David Young

      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.