Home
Reference Guide
This guide describes conceptual information about data design environment components when you want to use the data fabrication feature in HCL OneTest™ Server.
Schema design
A schema is a graphical data dictionary that contains metadata definitions of the structure of a document to generate test data. Schema provides visual cues for understanding the structure and complete definition of an object.
Functions and expressions
Date/time functions
ADDHOURS

Reference Guide
This guide describes conceptual information about data design environment components when you want to use the data fabrication feature in HCL OneTest™ Server.
- Files
  You add a file to a project to use it as input in the project. You can upload a file from your local file system to a project from the Files tab to generate test data. Alternatively, you can upload it when you define an action.
- Connections
  A connection defines the properties that are required to connect to an external resource. An action uses a connection to provide source data to a project or write data from a source to a target. Multiple actions can use the same connection. You can define both connections and actions at the project level.
- Schema design
  A schema is a graphical data dictionary that contains metadata definitions of the structure of a document to generate test data. Schema provides visual cues for understanding the structure and complete definition of an object.
  - Introduction to schema design
    Use the Schemas tab to define, modify, and view schemas. A schema describes the syntax, structure, and semantics of your data.
  - Type properties
    The properties of a type define the characteristics of the data objects of that type.
  - Item restrictions
    Item restrictions are an optional feature you can use to specify valid or invalid data objects for an item type. Item restrictions are grouped into three categories: Value, Character, and Range.
  - Components
  - Partitioning
  - Type inheritance
  - Schema analyzer
  - Distinguishable objects
  - Functions and expressions

ADDHOURS

The ADDHOURS function returns a time value that is the result of adding a specified number of hours to a given time.

Syntax:: ADDHOURS (single-datetime-item-expression, hours-expressed-as-signed-integer-expression)
Meaning:: ADDHOURS (any_datetime, number_of_hours_to_add)
Returns:: A single datetime item

The ADDHOURS function returns a single datetime item that is advanced from the original value of the single-datetime-item-expression by the specified number of hours-expressed-as-signed-integer-expression.

Examples

ADDHOURS(TODATETIME("Dec 31, 1999 23:59:00"), 2)
Returns: Jan 1, 2000 01:59:00
ADDHOURS(TODATETIME("Dec 31, 1999 23:59:00"), -25)
Returns: Dec 30, 1999 22:59:00
ADDHOURS(TODATETIME("23:59:00"), 2)
Returns: 01:59:00

If either argument is invalid, the result is "none". If the second argument is "none", the result is the first argument. If the first argument contains only a time portion, date changes are ignored. If the first argument contains only a date portion, the time portion 00:00:00 will be used in the calculation. If both arguments are "none", the result is "none".

Related functions

ADDDAYS
DATETONUMBER
NUMBERTODATE
TEXTTODATE
TODATETIME