CODEWITHSUNDEEP
amazon-redshift
user801116
user801116

Reputation:

How to get large number in Amazon Redshift?

I am trying to get epochtime (13 digits) after subtracting from task_end_time column using something like 

((task_end_time - to_date ('01 Jan 1970 00:00:00', 'DD Mon YYYY HH24:MI:SS')) * 24 * 3600* 1000)::bigint AS "log_datetime"

This gives me below exception

ERROR: XX000: Integer data overflow (multiplication)

enter image description here

Upvotes: 0

Views: 231

Answers (1)

AlexYes
AlexYes

Reputation: 4208

seems like all you actually need to do is

extract('epoch' from task_end_time) AS "log_datetime"

Upvotes: 1

Related Questions