Hi , I have 2 file from 2 system so have the datetime with different format
is that the case I need to change the righthand side datetime format?
I also have date, time, and the_hour_of_a_day exist in the file.
if datetime not working, could I use 'Date' and 'time' join at the same time to represent the datetime?
if I can, how?
and if I have the right format
could i use both datetime and also the other floor to join the data together? (inner join will be nice)
here is the app with the data for your info
Solved! Go to Solution.
first thing to know is the format of your 2 date fields:
on TempNew.dateTime, it is clear that it's a Timestamp format (YYYY/MM/DD hh:mm:ss)
but what is the format on the left part (Datetime) ? YYYY/MM/DD ??:??
If possible avoid join by timestamp fields, internally they are decimal numbers and chances are very high to have unmatched records which might result in cross join.
Thank you so much!
I test it, it is more accurate using 'Date'+'the hour of a day'+'floor' to join
if use datatine join i have 'the hour of a day' difference from different csv.
I did not know why
Thank you for the info. I thought maybe because of the time zoon different in the setting which I can not see