Posts by dougvolei • 19 points

• -1

  votes

  1

  answer

  130

  views

  Q: SLA calculation in Postgresql

  I want to calculate the time between the registration date so far (current_timestamp). Ex: If the record was 2019-03-01 09:11:17 and now it’s 2019-03-01 09:46:17 then it should return me 00:35:00…

  sql postgresql

  asked 5 years, 4 months ago dougvolei 19

• 0

  votes

  2

  answers

  123

  views

  Q: Query with date range with a variable

  I’m new in SQL and I’m breaking my head to mount a query that returns the desired results. I have a field whose date format is as follows: 2018-12-13T18:01:16.573-02:00. I have a variable $Período…

  sql

  asked 5 years, 6 months ago dougvolei 19