Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Verified Answer
Replies
9 replies
Answers
4 answers
Subscribers
9 subscribers
Views
3453 views
Users
0 members are here
datetime
general
expression rule
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
convert a Unix timestamp to DateTime
Ernesto De La Pena Molina
Certified Associate Developer
over 2 years ago
How can I convert a Unix timestamp to DateTime?
Discussion posts and replies are publicly visible
Top Replies
Mike Schmitt
over 2 years ago
in reply to
Dimitris Soulovaris
+3
suggested
Certified Lead Developer
I was going to suggest the intervalds() function, but upon testing it appears to not like large values for seconds . That said, the seconds() function appears to work here, too, if it helps anyone simplify…
Richard Michaelis
over 2 years ago
+3
suggested
Certified Senior Developer
Use the following plugin: https://community.appian.com/b/appmarket/posts/date-and-time-utilities It has two new functions: toUnixTimestamp - Returns the Unix timestamp from datetime fromUnixTimestamp…
Dimitris Soulovaris
over 2 years ago
+1
verified
Since a Unix timestamp is the number of seconds from 01/01/1970 till now, you can try something like this: (1651670870 / 86400) + datetime(1970, 01, 01, 00, 00)