Joining time and date attributes to form date_time attributes
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
Find more posts tagged with
Sort by:
1 - 3 of
31
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,
Wessel
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,
Wessel
I think you can do this:
date_add(Date, MyNumberOfMinutesAttributeGeneratedWithDateToNumerical, DATE_UNIT_MINUTE)
date_add(Date, MyNumberOfMinutesAttributeGeneratedWithDateToNumerical, DATE_UNIT_MINUTE)
Combine the two attributes with Concat into a text string and then use custom parse date to convert to a date_time.