Tomat Documentation
Tomat HomeCommunity
  • 👋Introduction to Tomat
  • Getting Started
    • Product Updates
    • Beginner's Guide
    • FAQ
  • Product overview
    • Home Page
    • Exploring Data
      • Data Catalog
      • Exploring Datasets
      • Statistics Panel
    • Designing Flows
      • Creating Flows
      • Flow Designer Guide
        • Working with Canvas
        • Using Groups
        • Working with Table
      • Managing Flows
      • Demo: Building a Simple Flow
    • Executing Flows
      • Running Flows
      • Jobs overview
    • Building Reports
      • Designing Reports
      • Running Reports
      • Reports Page
    • Connectors
      • Data Storages
      • Data Sources
      • Enrichments
    • Tomat Use Cases
  • Data Transformation
    • Transforms
      • Source
      • New Empty Table
      • Output
      • Chart
      • New Column
      • If...Then
      • Rolling Functions
      • Column Type
      • Columns Edit
      • Sort
      • Filter
      • Remove Duplicates
      • Split Text
      • Extract Text
      • Find and Replace Text
      • Match Text
      • Join
      • Union
      • Group By
      • Pivot
      • Unpivot
      • To JSON
      • From JSON
      • API Call
      • AI Column
      • AI Table
    • Formulas
      • What are Formulas?
      • Math Functions
        • Abs
        • Ceiling
        • Exp
        • Floor
        • IsEven
        • IsOdd
        • Ln
        • Log
        • Log10
        • Mod
        • Pi
        • Power
        • Quotient
        • Round
        • RoundDown
        • RoundUp
        • Sign
        • Sqrt
        • Truncate
      • Trigonometric Functions
        • Acos
        • Asin
        • Atan
        • Atan2
        • Cos
        • Cot
        • Degrees
        • Radians
        • Sin
        • Tan
      • String Functions
        • Compare
        • Concat
        • Contains
        • In
        • CountMatches
        • CountMatchesRegexp
        • EndsWith
        • EndsWithRegexp
        • Extract
        • FindMatchOfString
        • FindMatchOfRegexp
        • FindMatchesOfString
        • FindMatchesOfRegexp
        • Left
        • Length
        • Lower
        • Matches
        • Pad
        • ProperCase
        • RemoveSymbols
        • RemoveWhitespaces
        • Repeat
        • Replace
        • ReplaceRegexp
        • Reverse
        • Right
        • Spaces
        • Split
        • SplitRegexp
        • StartsWith
        • StartsWithRegexp
        • Stuff
        • Substring
        • SubstringDelimiter
        • SubstringRegexpDelimiter
        • Trim
        • Upper
      • Date & Time Functions
        • Date
        • DateAdd
        • DateAdd
        • DateDiff
        • DateDiff2
        • DateFromParts
        • DateTime
        • DateTimeFromParts
        • DateTrunc
        • DayName
        • DayOfMonth
        • DayOfWeek
        • DayOfYear
        • Hour
        • Minute
        • Month
        • MonthName
        • Now
        • Quarter
        • Second
        • Time
        • TimeFromParts
        • Today
        • Week
        • Year
      • Aggregate Functions
        • Array
        • ArrayIf
        • Avg
        • AvgIf
        • Count
        • CountA
        • CountIf
        • CountUnique
        • Max
        • MaxIf
        • Median
        • MedianIf
        • Min
        • MinIf
        • Mode
        • ModeIf
        • Percentile
        • Quartile
        • StdDev
        • StdDevIf
        • Sum
        • SumIf
        • SumProduct
        • Variance
        • VarianceIf
      • Conversion Functions
        • ToArray
        • ToBoolean
        • ToDate
        • ToDateTime
        • ToDecimal
        • ToInteger
        • ToObject
        • ToTime
        • ToString
      • Misc Functions
        • At
        • IsMissing
        • RowNumber
        • Random
        • If
        • Coalesce
        • True
        • False
        • Null
        • $target
      • Window Functions
      • Custom Functions
      • Data Types
      • Supported Date Parts
      • Regex: List of Tokes
  • PRICING & BILLING
    • Plans, Subscriptions, and Credits
    • Tomat for Education
  • Integrations
    • Data Storages
      • Snowflake
      • PostgreSQL
  • Tutorials
    • Merge Columns
    • Join Types
    • Union Introduction
    • Window Functions
    • What is Unpivot?
    • JSON Format Tutorial
    • Using Regex
Powered by GitBook
On this page
  • Available conversions
  • As parameters for functions
  1. Data Transformation
  2. Formulas

Data Types

Supported data types and conversion variants between them

Available conversions

Functions
String
Integer
Decimal
Boolean
DateTime
Date
Time
Array
Object

To -> String

-

ToString()

ToString()

ToString()

ToString()

ToString()

ToString()

ToString()

ToString()

To -> Integer

ToInt(format)

-

ToInt() = Trunc()

ToInt()

ToInt()

ToInt()

ToInt()

No

No

To -> Decimal

ToDecimal(format)

ToDecimal()

-

ToDecimal()

ToDecimal()

ToDecimal()

ToDecimal()

No

No

To -> Boolean

ToBool()

ToBool()

ToBool()

-

No

No

No

No

No

To -> DateTime

ToDateTime(format)

No

No

No

-

ToDateTime()

No

No

No

To -> Date

ToDate(format)

No

No

No

ToDate()

-

No

No

No

To -> Time

ToTime(format)

No

No

No

ToTime()

No

-

No

No

To -> Array

ToArray()

ToArray()

ToArray()

ToArray()

ToArray()

ToArray()

ToArray()

-

ToArray()

To -> Object

ToObject()

ToObject()

ToObject()

ToObject()

ToObject()

ToObject()

ToObject()

ToObject()

-

As parameters for functions

if Yes then functions are working with this types as parameters, no Explicit conversion is needed

Functions
String
Integer
Decimal
Boolean
DateTime
Date
Time
Array
Object

-

Yes

Yes

-

-

-

-

-

-

-

Yes

Yes

By function

By function

By function

By function

-

-

Aggr -> Math

-

Yes

Yes

By function

By function

By function

By function

-

-

String

Yes

-

-

-

-

-

-

-

-

Yes

-

-

-

-

-

-

-

-

-

-

-

-

Yes

Yes

Yes

-

-

PreviousCustom FunctionsNextSupported Date Parts

Last updated 1 year ago

Math functions
Window functions
Regex
DateTime