You can translate the question and the replies:

Converting timestampz to epoch time

Hi, I have seen previous enquiries about a function to convert to and from epoch time before. Are there any possibility that this function will be prioritized in future patches? The autogenerated column "expirationDate" uses epoch time for the expiration of the cached data in a cachetable, so Denodo VDP certainly uses Epoch time "under the hood" ? The reason I need epoch time, is that I need to send Epoch time string as an interpolation variable to a data source. And store the data in an incrementally in an MSSQLDB fully cached table. Br Kristoffer
Epoch time timestamp Interpolation Variables
user
04-02-2020 03:59:03 -0500

1 Answer

Hi, I would achieve this by utilizing some of the Denodo[ Datetime Processing Functions](https://community.denodo.com/docs/html/browse/latest/vdp/vql/appendix/syntax_of_condition_functions/date_processing_functions#datetime-processing-functions) such as **now** and **extract** or I would also write a custom function that would do the conversion to epoch time. You can find the samples to create custom functions at <DENODO_HOME>/samples/vdp/customFunctions. A separate function to do handle these conversions is already in our roadmap For more information refer to the [Developing Custom Functions](https://community.denodo.com/docs/html/browse/latest/vdp/developer/developing_extensions/developing_custom_functions/developing_custom_functions#developing-custom-functions) that explains in detail the steps to create a custom function. Hope this helps!
Denodo Team
06-02-2020 07:43:50 -0500
You must sign in to add an answer. If you do not have an account, you can register here