Click or drag to resize
Timestamp data type
Print this page

The data type Timestamp represents a date-and-time value.

Formatting

Timestamps from TDE default to UTC (see DateTime conversion). In the [Output] section, you can convert these values to the time zone and format you need:

[Output]
PurchaseTime(yyyy-MM-dd HH:mm, PST) = Input.SwipeTime  # converts and formats from UTC to time zone
Field length

The effective range of this data type is: 00:00:00.0000000, January 1, 0001 to 23:59:59.9999999, December 31, 9999

JavaScript conversion

When you use the optional [Script] section to insert your own JavaScript functions, Timestamp maps to JavaScript Date, so you can manipulate it as a native JavaScript date object.

Creation
JavaScript
var myDate1 = new Date();
var myDate2 = new Date(milliseconds);
var myDate3 = new Date(dateString);
var myDate4 = new Date(year, month, day, hours, minutes, seconds, milliseconds);
Methods

These are the native JavaScript methods for Date objects:

  • getDate() — Returns the day of the month (from 1-31)

  • getDay() — Returns the day of the week (from 0-6)

  • getFullYear() — Returns the year (four digits)

  • getHours() — Returns the hour (from 0-23)

  • getMilliseconds() — Returns the milliseconds (from 0-999)

  • getMinutes() — Returns the minutes (from 0-59)

  • getMonth() — Returns the month (from 0-11)

  • getSeconds() — Returns the seconds (from 0-59)

  • getTime() — Returns the number of milliseconds since midnight Jan 1, 1970

  • getTimezoneOffset() — Returns the time difference between UTC time and local time, in minutes

  • getUTCDate() — Returns the day of the month, according to universal time (from 1-31)

  • getUTCDay() — Returns the day of the week, according to universal time (from 0-6)

  • getUTCFullYear() — Returns the year, according to universal time (four digits)

  • getUTCHours() — Returns the hour, according to universal time (from 0-23)

  • getUTCMilliseconds() — Returns the milliseconds, according to universal time (from 0-999)

  • getUTCMinutes() — Returns the minutes, according to universal time (from 0-59)

  • getUTCMonth() — Returns the month, according to universal time (from 0-11)

  • getUTCSeconds() — Returns the seconds, according to universal time (from 0-59)

  • getYear() — Deprecated. Use the getFullYear() method instead

  • parse() — Parses a date string and returns the number of milliseconds since midnight of January 1, 1970

  • setDate() — Sets the day of the month of a date object

  • setFullYear() — Sets the year (four digits) of a date object

  • setHours() — Sets the hour of a date object

  • setMilliseconds() — Sets the milliseconds of a date object

  • setMinutes() — Set the minutes of a date object

  • setMonth() — Sets the month of a date object

  • setSeconds() — Sets the seconds of a date object

  • setTime() — Sets a date and time by adding or subtracting a specified number of milliseconds to/from midnight January 1, 1970

  • setUTCDate() — Sets the day of the month of a date object, according to universal time

  • setUTCFullYear() — Sets the year of a date object, according to universal time (four digits)

  • setUTCHours() — Sets the hour of a date object, according to universal time

  • setUTCMilliseconds() — Sets the milliseconds of a date object, according to universal time

  • setUTCMinutes() — Set the minutes of a date object, according to universal time

  • setUTCMonth() — Sets the month of a date object, according to universal time

  • setUTCSeconds() — Set the seconds of a date object, according to universal time

  • toDateString() — Converts the date portion of a Date object into a readable string

  • toISOString() — Returns the date as a string, using the ISO standard

  • toJSON() — Returns the date as a string, formated as a JSON date

  • toLocaleDateString() — Returns the date portion of a Date object as a string, using locale conventions

  • toLocaleTimeString() — Returns the time portion of a Date object as a string, using locale conventions

  • toLocaleString() — Converts a Date object to a string, using locale conventions

  • toString() — Converts a Date object to a string

  • toTimeString() — Converts the time portion of a Date object to a string

  • toUTCString() — Converts a Date object to a string, according to universal time

  • UTC() — Returns the number of milliseconds in a date string since midnight of January 1, 1970, according to universal time

  • valueOf() — Returns the primitive value of a Date object