Hi all,
I have user property with timestamp in `1619000000.571` format. That’s UNIX timestamp with millis as a float value.
I want to put that value in LONG_TO_TIME, but it doesn’t accept it in that format.
Tried SPLIT to remove 2nd part of timestamp, but SPLIT returns String, and LONG_TO_DATE doesn’t work with Strings. Which options do I have?
Thanks,
Ostap
Hi 
I’m happy to help!
I checked internally and found that you can get around this by doing DATE_TIME_FORMATTER (PROPERTY , "s","yyyy/MM/dd").
This help doc page describes how to use the DATE_TIME_FORMATTER function. In this case, I am telling the formatter we are getting a value in seconds (“s”), and I want a return format like 2021/04/21 (“yyyy/MM/dd”).
If you want to output to look like the LONG_TO_TIME function, then this “YYYY-MM-dd HH
ss” should be the output format.
Can you try the above and let me know how that works for you?
Thank you, Belinda. It worked as expected!
Didn’t know about that `”s”` functionality in SimpleDateFormat. Thanks for sharing that internal workaround.
Our Derived Properties doc does have a handy link to the SimpleDateFormat functionality list. I’m going to share it here in case other Community members find it useful: https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html
I agree with OP that a STRING_TO_NUMBER function would be useful.
Im my case I want to use "split" to pull a value from a longer string, then use math functions on it.
Hi
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.