Correct syntax

From: "Victor Sterpu" <victor(at)caido(dot)ro>
To: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Correct syntax
Date: 2014-04-11 08:58:53
Message-ID: em212b3363-b46e-4efa-8a76-d367bddb4468@victor-pc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How would I write sutch a query?
SELECT to_timestamp ('10-10-2013 15:00', 'DD-MM-YYYY HH24:MI') +
interval REPLACE('1.30', '.', ':')||' hours'
This gives error at REPLACE.
Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vik Fearing 2014-04-11 09:15:13 Re: Correct syntax
Previous Message Rémi Cura 2014-04-11 07:51:33 Re: [postgis-users] design question: how to geocode multiple dynamic "city, country"?