SELECT * , extract(epoch from mytimestamp) - lag(extract(epoch from mytimestamp)) over (PARTITION BY user_id order by mytimestamp) as time_interval FROM toy_data_psql;
Hi @Herve, I believe the issue is the storage type of the ``mytimestamp`` column. It should be in a Date format as opposed to string. We'll be improving our instructions for this tutorial to make this a little clearer.
Hi @Herve , thanks for alerting us to this. We'll investigate and get back to you.
Hi @Herve, I believe the issue is the storage type of the ``mytimestamp`` column. It should be in a Date format as opposed to string. We'll be improving our instructions for this tutorial to make this a little clearer.
Thanks @SeanA