How to add HOUR in a DateTime column in TIBCO Data Virtualization?

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) ?