How to do custom calculations with timestamps


#1

Feeling a bit lost in terms of documentation around custom calculations,

specifically, I have a timestamp field, that I would like to add/adjust by a certain amount (stored in another field in seconds).

Is there some way to cast it ? or a datetime function that can be used to manipulate it?


#2

Further digging seems to indicate that the following does the trick:
TIMESTAMPADD(Second,TIMEZONE,TIMESTAMP)


#3

Was hiding in this documentation: https://www.mapd.com/docs/latest/mapd-core-guide/dml/#date-time-function-support

(the core guide, not the immerse guide)


#4

Hi,

Glad you found it all.

Hope you don’t mind I edited your post a little to make the URL point exactly to the date and time functions

regards