Preface
The Transformation Language
Constants
Operators
Variables
- Built-in Variables
  - SYSDATE
    - Example
- Local Variables
Dates
Functions
- Function Categories
  - Aggregate Functions
  - Aggregate Functions and Nulls
    - Filter Conditions
  - Character Functions
  - Complex Functions
  - Conversion Functions
  - Data Cleansing Functions
  - Date Functions
  - Encoding Functions
  - Financial Functions
  - Numeric Functions
  - Scientific Functions
  - Special Functions
  - String Functions
  - Test Functions
  - Window Functions
- ABORT
- ABS
- ADD_TO_DATE
- AES_DECRYPT
- AES_ENCRYPT
- ANY
- ARRAY
- ASCII
- AVG
- CAST
- CEIL
- CHOOSE
- CHR
- CHRCODE
- COLLECT_LIST
- COLLECT_MAP
- COMPRESS
- CONCAT
- CONCAT_ARRAY
- CONVERT_BASE
- COS
- COSH
- COUNT
- CRC32
- CREATE_TIMESTAMP_TZ
- CUME
- DATE_COMPARE
- DATE_DIFF
- DEC_BASE64
- DECODE
- DECOMPRESS
- ENC_BASE64
- ERROR
- EXP
- EXTRACT_STRUCT
- FIRST
- FLOOR
- FV
- GET_DATE_PART
- GET_TIMEZONE
- GET_TIMESTAMP
- GREATEST
- IIF
- IN
- INDEXOF
- INITCAP
- INSTR
- ISNULL
- IS_DATE
- IS_NUMBER
- IS_SPACES
- LAG
- LAST
- LAST_DAY
- LEAD
- LEAST
- LENGTH
- LN
- LOG
- LOWER
- LPAD
- LTRIM
- MAKE_DATE_TIME
- MAP
- MAP_FROM_ARRAYS
- MAP_KEYS
- MAP_VALUES
- MAX (Dates)
- MAX (Numbers)
- MAX (String)
- MD5
- MEDIAN
- METAPHONE
- MIN (Dates)
- MIN (Numbers)
- MIN (String)
- MOD
- MOVINGAVG
- MOVINGSUM
- NPER
- PARSE_JSON
- PARSE_XML
- PERCENTILE
- PMT
- POWER
- PV
- RAND
- RATE
- REG_EXTRACT
- REG_MATCH
- REG_REPLACE
- REPLACECHR
- REPLACESTR
- RESPEC
- REVERSE
- ROUND (Dates)
- ROUND (Numbers)
- RPAD
- RTRIM
- SET_DATE_PART
- SIGN
- SIN
- SINH
- SIZE
- SOUNDEX
- SQL_LIKE
- SQRT
- STDDEV
- STRUCT
- STRUCT_AS
- SUBSTR
- SUM
- SYSTIMESTAMP
- TAN
- TANH
- TIME_RANGE
- TO_BIGINT
- TO_CHAR (Dates)
- TO_CHAR (Numbers)
- TO_DATE
- TO_DECIMAL
- TO_DECIMAL38
- TO_FLOAT
- TO_INTEGER
- TO_TIMESTAMP_TZ
- TRUNC (Dates)
- TRUNC (Numbers)
- UPPER
- UUID4
- UUID_UNPARSE
- VARIANCE

Transformation Language Reference

10.5.1
- 10.5.6
- 10.5.4
- 10.5
- 10.4.0

Back Next

GET_TIMESTAMP

Returns the date/time value for a timestampWithTZ input type. The date/time returned will be in the requested time zone, which can be provided as the second argument. If the time zone value is not specified in the second argument, the function returns the timestamp part of the input timestampWithTZ value.

For example:

GET_TIMESTAMP(Timestamp with Time Zone,“+08:30”)

The first argument, timestamp with time zone has (+05:30) as the time zone value. The function returns the timestamp in the time zone specified as the second argument, (+08:30).

The output port must be date/time for GET_TIMESTAMP expressions.

Syntax

GET_TIMESTAMP (timestamp_with_timezone_value, [timezone_value])

The following table describes the arguments for this command:

Argument	Required/ Optional	Description
timestamp_with_timezone_value	Required	Must be a timestamp with time zone data type. You can enter any valid transformation expression.
timezone_value	Optional	Must be a string data type. The string must be a character string. Passes the values you want to display for time zone based on which the function can return the timestamp. You can enter any valid transformation expression. If you do not specify the time zone, the function returns the timestamp part of the first argument.

Return Value

Returns the timestamp value in time zone offset or region specified.

If the time zone value is not passed, the function returns the timestamp part of the first argument.

NULL if the input is a null value.

Example

INPUT VALUE	RETURN VALUE
'1996-01-05 10:45:00.221111111 AM America/Los_Angeles’, '+05:30'	Returns the timestamp value in time zone offset of '+05:30': ’1996-01-06 12:15:00.221111111 AM’
'1996-01-05 10:45:00.221111111 AM America/Los_Angeles’, 'GMT’	Returns the timestamp value in the ‘GMT’ time zone: ‘1996-01-05 06:45:00.221111111 PM’
'1996-01-05 10:45:00.221111111 AM America/Los_Angeles’	As the time zone value is not passed as the second input parameter, the timestamp is returned: ‘1996-01-05 10:45:00.221111111 AM’

INPUT VALUE

RETURN VALUE

'1996-01-05 10:45:00.221111111 AM America/Los_Angeles’, '+05:30'

Returns the timestamp value in time zone offset of '+05:30':
’1996-01-06 12:15:00.221111111 AM’

'1996-01-05 10:45:00.221111111 AM America/Los_Angeles’, 'GMT’

Returns the timestamp value in the ‘GMT’ time zone:
‘1996-01-05 06:45:00.221111111 PM’

'1996-01-05 10:45:00.221111111 AM America/Los_Angeles’

As the time zone value is not passed as the second input parameter, the timestamp is returned:
‘1996-01-05 10:45:00.221111111 AM’

Rename Saved Search

Table of Contents

Transformation Language Reference

Transformation Language Reference

GET_TIMESTAMP

GET_TIMESTAMP

Syntax

Return Value