Stay organized with collections
Save and categorize content based on your preferences.
timestamp.as_unix_seconds
timestamp.as_unix_seconds(timestamp [, time_zone])
Description
This function returns an integer representing the number of seconds past a Unix epoch for the given timestamp string.
timestamp is a string representing a valid epoch timestamp. The format needs
to be %F %T.time_zone is optional and is a string representing a time zone. If
omitted, the default is GMT. You can specify time zones using string
literals. The options are as follows:
Here are examples of valid time_zone specifiers, which you can pass as the second argument to time extraction functions:
"America/Los_Angeles", or "-08:00". ("PST" is not supported)
"America/New_York", or "-05:00". ("EST" is not supported)
"Europe/London"
"UTC"
"GMT"
Param data types
STRING, STRING
Return type
INT
Code samples
Example 1
Valid epoch timestamp
timestamp.as_unix_seconds("2024-02-22 10:43:00") = 1708598580
Example 2
Valid epoch timestamp with the America/New_York time zone
timestamp.as_unix_seconds("2024-02-22 10:43:00", "America/New_York") = 1708616580
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-07-14 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-07-14 UTC."],[[["\u003cp\u003eThis function, \u003ccode\u003etimestamp.as_unix_seconds\u003c/code\u003e, converts a given timestamp string into the number of seconds past the Unix epoch.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003etimestamp\u003c/code\u003e input must be a string in the \u003ccode\u003e%F %T\u003c/code\u003e format, while the optional \u003ccode\u003etime_zone\u003c/code\u003e input is a string representing a time zone, defaulting to GMT if omitted.\u003c/p\u003e\n"],["\u003cp\u003eValid \u003ccode\u003etime_zone\u003c/code\u003e formats include TZ database names like "America/Los_Angeles" or offsets like "-08:00", but abbreviations such as "PST" are not supported.\u003c/p\u003e\n"],["\u003cp\u003eThe function's return type is an integer (\u003ccode\u003eINT\u003c/code\u003e) and it is supported in both Rules and Search functionalities.\u003c/p\u003e\n"]]],[],null,["### timestamp.as_unix_seconds\n\nSupported in: \n[Rules](/chronicle/docs/detection/default-rules) [Search](/chronicle/docs/investigation/udm-search) \n\n timestamp.as_unix_seconds(timestamp [, time_zone])\n\n#### Description\n\nThis function returns an integer representing the number of seconds past a Unix epoch for the given timestamp string.\n\n- `timestamp` is a string representing a valid epoch timestamp. The format needs to be `%F %T`.\n- `time_zone` is optional and is a string representing a time zone. If omitted, the default is `GMT`. You can specify time zones using string literals. The options are as follows:\n - The TZ database name, for example `America/Los_Angeles`. For more information, see the [list of tz database time zones on Wikipedia](https://en.wikipedia.org/wiki/List_of_tz_database_time_zones).\n - The time zone offset from UTC, in the format`(+|-)H[H][:M[M]]`, for example: \"-08:00\".\n\nHere are examples of valid `time_zone` specifiers, which you can pass as the second argument to time extraction functions: \n\n \"America/Los_Angeles\", or \"-08:00\". (\"PST\" is not supported)\n \"America/New_York\", or \"-05:00\". (\"EST\" is not supported)\n \"Europe/London\"\n \"UTC\"\n \"GMT\"\n\n#### Param data types\n\n`STRING`, `STRING`\n\n#### Return type\n\n`INT`\n\n#### Code samples\n\n##### Example 1\n\nValid epoch timestamp \n\n timestamp.as_unix_seconds(\"2024-02-22 10:43:00\") = 1708598580\n\n##### Example 2\n\nValid epoch timestamp with the America/New_York time zone \n\n timestamp.as_unix_seconds(\"2024-02-22 10:43:00\", \"America/New_York\") = 1708616580"]]
