Skip site navigation (1) Skip section navigation (2)

Re: time series data

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To:
Cc: azwa(at)nc(dot)com(dot)my, pgsql-sql(at)postgresql(dot)org
Subject: Re: time series data
Date: 2004-01-21 11:36:18
Message-ID: 400E6432.4050306@klaster.net (view raw or flat)
Thread:
Lists: pgsql-sql
Dnia 2004-01-21 10:37, Użytkownik Tomasz Myrta napisał:

> Use this integer sequence and interval datatype to get date result:
> your_date='1994-01-01'::date+'1 day'::integer * time_key
				        ^^^^^^^
Sorry, use interval here.

Regards,
Tomasz Myrta

In response to

pgsql-sql by date

Next:From: Rajesh Kumar MallahDate: 2004-01-21 14:00:12
Subject: array_lower /array_prepend doubt
Previous:From: Tomasz MyrtaDate: 2004-01-21 09:37:11
Subject: Re: time series data

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group