2 Respuestas
- Más nuevo
- Más votos
- Más comentarios
0
I did manage to find one solution so far to this.
You can either:
-
Convert Timestamps to ms before doing your math with to_milliseconds()
to_milliseconds( (2022-04-29 13:15:53::Timestamp)) - to_milliseconds((2022-04-29 12:58:30::Timestamp)) = 1043000::int?
-
Or apparently you can cast an Interval with the same function to a number
to_milliseconds((2022-04-29 13:15:53::Timestamp) - (2022-04-29 12:58:30::Timestamp)) = 1043000::int?
Again if someone could point me to a the entire supported SQL syntax for this service that would be awesome. I do not see the function to_milliseconds() even listed in the documentation I linked to above.
Thank you for any help offered.
respondido hace 2 años
0
Here is the final answer I was looking for, and now it's here for reference!
As vaguely mentioned here, but not explicitly stated as such the syntax is TrinoDB's with support for some? all? functions.
Here is a link to the datetime functions specifically: https://trino.io/docs/current/functions/datetime.html
respondido hace 2 años
Contenido relevante
- OFICIAL DE AWSActualizada hace un año
- OFICIAL DE AWSActualizada hace 3 años
- OFICIAL DE AWSActualizada hace un año