Joining time and date attributes to form date_time attributes
wessel
New Altair Community Member
Dear all,
What is an efficient way of combining date and time attributes into a date time attribute?
E.g. first attribute = days of epoch e.g. 31-11-2013
E.g. second attribute = time of day e.g. 14:55:02
Best regards,
Wessel
What is an efficient way of combining date and time attributes into a date time attribute?
E.g. first attribute = days of epoch e.g. 31-11-2013
E.g. second attribute = time of day e.g. 14:55:02
Best regards,
Wessel
Tagged:
0
Answers
-
Generate Attributes operator is the first I can think of.
Combine the two attributes with Concat into a text string and then use custom parse date to convert to a date_time.0 -
Hey Edward,
You are right, this works, thanks.
If possible, I would prefer to not have to parse dates.
This was missing from my original question.
In generate attributes there seems to be a date_add() function.
Best regards,
Wessel0 -
I think you can do this:
date_add(Date, MyNumberOfMinutesAttributeGeneratedWithDateToNumerical, DATE_UNIT_MINUTE)0