How to get value from range datetime from date format to bigint in postgresql
You do not convert datetime to bigint, you use timestamp with time zone. To convert a string to a timestamp with time zone, use the to_timestamp function.