Skip to main content Skip to complementary content

Timestamp# - script and chart function

Timestamp#() evaluates an expression as a date and time value, in the timestamp format set in the data load script or the operating system, unless a format string is supplied.

Syntax:  

timestamp#(text[, format])

Return data type: dual

Arguments
Argument Description
text The text string to be evaluated.
format

String describing the format of the text string to be evaluated. If omitted, the short date format, time format, and decimal separator set in the operating system is used. ISO 8601 is supported for timestamps.

Descriptions for number and time formats

Example: Chart expressions
Example Result
Timestamp(Timestamp#('2015-09-15T12:13:14')) Returns 9/15/2015 12:13:14 PM
Timestamp(Timestamp#('1952-10-16T13:14:00+0200')) Returns 10/16/1952 11:14:00 AM
Timestamp(Timestamp#('1109-03-01T14:15 ')) Returns 3/1/1109 2:15:00 PM

Example - Timestamp# fundamentals

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!