search

inbo / fish-tracking

🐟 Collection of scripts for processing and analysing fish tracking data
3 stars 0 forks source link

Join release_date and release_time #9

Closed peterdesmet closed 9 years ago

peterdesmet commented 9 years ago

Before I can do this, all times have to be UTC. Need to know which ones I have to update to UTC.

peterdesmet commented 9 years ago

Join:

UPDATE fish_tracking_tags
SET released_at = released_at + to_timestamp(released_at_time, 'HH24:MI:SS')::time
WHERE released_at_time IS NOT NULL

Use UTC for Demer:

UPDATE fish_tracking_tags
SET released_at = released_at - time '02:00'
WHERE project = 'Demer' AND released_at_time IS NOT NULL