Covert Time to UNIX Time

Can you provide an example to make sure I suggest something that suits your requirement ? Is it really a long out of the date and time what you want to generate?

I want to convert the Appian current timestamp into THE UTC format (Current Unix Timestamp).
e.g: 10/08/2016 @ 6:43am (UTC) is equivalent to: "1475909014". I want "1475909014" as an output

I went through the functions documentation forum.appian.com/.../Appian_Functions.html and didn't find a way to convert to a timestamp.

Maybe building a custom function that takes a date and time and returns the time stamp. Basically if you code your custom function to return a long, and you just simply return the date and time you're passing, since the product maps it to java.sql.Timestamp I think you'll get exactly what you need.


Example


@Function
public Long getLocalTime(ServiceContext sc, @Parameter Timestamp datetime) {

return           datetime;
}

Here is a Expression rule that you may use to convert time to a UNIX timestamp. It makes use of the fact that the difference between two datetimes is an interval. I have used it to convert the current datetime (now()) to UNIX timestamp
with(

local!unixEpoch : fn!datetime(1970, 1, 1, 0,0,0,0),

local!intervalDiff: fn!now() - local!unixEpoch,

local!stringintervalDiff: fn!tostring(local!intervalDiff),

local!days: fn!tointeger(local!intervalDiff),

local!stringPartExcludingDays: fn!split(local!stringintervalDiff, "::")[2],

local!splitPartExcludingDays: fn!split(local!stringPartExcludingDays, ":"),


local!hours: fn!tointeger(local!splitPartExcludingDays[1]),

local!minutes: fn!tointeger(local!splitPartExcludingDays[2]),

local!seconds: fn!tointeger(local!splitPartExcludingDays[3]),

local!days*24*3600 + local!hours*3600 + local!minutes*60 + local!seconds

)

Please create a rule input and use it instead of fn!now() in the above expression. It will give you the expected output for the sample input you have mentioned.

Thanks chetany. It is working properly.

And here's a suggestion from someone to do it the other way around forum.appian.com/.../f-159035

@Eduardo, thanks for sharing. It can be useful to know how to do it the other way.

Another option: forum.appian.com/.../summary

Although that plug-in only works if what you want to convert to the timestamp is "now()". Just thought it'd make sense to mention it.