How to add HOUR in a DateTime column in TIBCO Data Virtualization?
book
Article ID: KB0073034
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
All supported versions
Description
This article details how to add HOUR in a DateTime column in TIBCO Data Virtualization (TDV).
Environment
All Supported Operating Systems
Resolution
To increase the hour part of a TimeStamp or DateTime column in TDV, users have to use .0416666 value to add one hour i.e. 1/24, irrespective of the data source being used.
Users can enter the following expression in TDV to add one hour:
[Column Name] + .0416666 as New_column
Issue/Introduction
How to add HOUR in a DateTime column in TIBCO Data Virtualization (TDV) ?