How to add HOUR in a DateTime column in TIBCO Data Virtualization?
Article ID: KB0073034
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
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) ?
Feedback
Yes
No
Powered by
