Hello guys!!, I’m a very amateur/new user and I’m trying to get logs between a Date and Time Range from a DynamoDB where the date is in Unix Timestamp format. I’ve tried to use FROM_UNIXTIME() and other functions but I can’t get the results I need (I think this is because uses DQL instead of SQL?), I need to show logs between a date range with the Redash built-in date parameters. The timestamp() function is the only one that looks functional but it doesn’t accept strings as arguments to convert it to unix timestamp…, please, I really need to solve this, it is possible in an excel sheet, I supose I’m missing a lot for my little experience in the field, here is my code:
“uDate” is the column with the unix timestamps and “mensaje” is the column with the logs.
Thank you! Any help would be much appreciated.