currentTimestamp (Function)
When no argument is provided, function returns the system current
timestamp in yyyy-MM-dd HH:mm:ss format, and when a time zone is
provided as an argument, it converts and return the current system time
to the given time zone format.
Syntax
<STRING> time:currentTimestamp()
<STRING> time:currentTimestamp(<STRING> timezone)
Query Parameters
| Name | Description | Default Value | Possible Data Types | Optional | Dynamic |
|---|---|---|---|---|---|
| timezone | The time zone to which the current time need to be converted. For example, Asia/Kolkata, PST. Get the supported time zone IDs from here. | System timezone | STRING | Yes | No |
Example 1
@info(name = 'currentTimestampExample')
SELECT time:currentTimestamp() AS currentTimestamp;
The currentTimestampExample demonstrates the use of the time:currentTimestamp() function to get the current system time in the yyyy-MM-dd HH:mm:ss format. The function returns a string representing the current timestamp, such as 2023-04-25 12:34:56.
Example 2
CREATE STREAM InputStream (eventTime long);
CREATE SINK STREAM OutputStream (eventTime long, currentTimestamp string);
@info(name = 'currentTimestampStreamWorker')
INSERT INTO OutputStream
SELECT eventTime, time:currentTimestamp('Asia/Kolkata') AS currentTimestamp
FROM InputStream;
The currentTimestampStreamWorker processes events from the InputStream and uses the time:currentTimestamp('Asia/Kolkata') function to get the current system time converted to the Asia/Kolkata timezone in the yyyy-MM-dd HH:mm:ss format. The query outputs the eventTime and a string representing the current timestamp as the currentTimestamp attribute for each event to the OutputStream.
Example 3
CREATE STREAM InputStream (eventTime long);
CREATE SINK STREAM OutputStream (eventTime long, currentTimestamp string);
@info(name = 'currentTimestampCSTStreamWorker')
INSERT INTO OutputStream
SELECT eventTime, time:currentTimestamp('CST') AS currentTimestamp
FROM InputStream;
The currentTimestampCSTStreamWorker processes events from the InputStream and uses the time:currentTimestamp('CST') function to get the current system time converted to the CST timezone in the yyyy-MM-dd HH:mm:ss format. The query outputs the eventTime and a string representing the current timestamp as the currentTimestamp attribute for each event to the OutputStream.