Hi! I performed a union between two selects. In the first select the date field (ajt.DTC_MOV)) is numeric in datetime 22.3 format. The results are in the format 03JAN2019:00:00:00.000. In the second select, the date field (ajt.DTC_MOV) is numeric without a defined format (the dates are extracted from an excel spreadsheet). The results are in the format 1935705600. When performing the UNION data field it shows the results in the format 1935705600. My question is how to display them in the format 03JAN2019:00:00:00.000. I've tried the solutions below without success in the select clause: - DHMS(ajt.DTC_MOV,0,0,0) - datepart (DHMS(ajt.DTC_MOV,0,0,0)) format = datetime22.3 - datepart (ajt.DTC_MOV) format = datetime22.3 Thanks.
... View more