---
title: "DateTime Transform Overview"
slug: "datetime-transform-overview"
updated: 2023-11-06T16:09:32Z
published: 2023-11-06T16:09:32Z
canonical: "docs.datajet.app/datetime-transform-overview"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# DateTime Transform Overview

## Date Transform Functions

## Functions that operate on DateTime fields and that manipulate hours, minutes and seconds

## Purpose

Use Date Transform functions to:

- Manipulate hours, minutes and seconds in a datetime field
- Calculate elapsed time in hours, minutes and seconds
- Segment data into hours, minutes and seconds

## Return Value

| Property | Value | Notes |
| --- | --- | --- |
| **FieldType** | Integer | Datetime transforms return integer fields. |
| **FieldSize** | Low / Med / High | Low - up to 250 unique values Med - Up to 65,630 unique values High - up to 1,000,000 unique values |
| **DataType** | Discrete / Continuus | DateTime transformscan be discrete or continuous |
| **DataSize** | Short / Integer | Short - Up to 65,630 unique values |

### Parameters

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1699286690475.png)

| Parameter | JSON | Description |
| --- | --- | --- |
| **Table** | “targetTable”: “MyTableName” | The target table on which the new field will be created |
| **Filter** | “dataset”: {DataSet_JSON} | Optional. If a filter is applied, records not in the filter recordset will be returned as null. |
| **Date** **Function** | “p1”: “” | Select the DateTime Transform function from the drop-down list. Specifies the function to use. |
| **A - C** | “p2-4”: “NumericFieldName” “p2-4”: “#YYYY-MM-DD” “p2-4”: “#YYYY-MM-DD HH:MM:SS” “p2-4”: “#N*” | Fields/Inputs to use for A-C. The date from which to extract the hour, minute and second *Supports:* - **DataType:** Discrete / Continuous - **Field Type:** DateTime - **Fixed Value:** #YYYY-MM-DD HH:MM:SS, e.g. #2021-04-05 11:01:08 - **Fixed Value:** #NN, e.g. #10 |
| Name | "name" : "FieldName" | Required. The name of the field to create. |

## JSON Sample

```json
{
  "method": "BuildBakedField",
  "targetTable": "PA_All",
  "name": "ElapsedSecs",
  "function": "datetimetransform",
  "p1": "SECSDIFF(A,B)",
  "p2": "#2020-11-03 19:39:48",
  "p3": "TimeStamp",
  "project": "Election5"
}
```

##