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

Re: issue with an assembled date field

From: brian <brian(at)zijn-digital(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: issue with an assembled date field
Date: 2008-02-29 18:11:22
Message-ID: 47C84ACA.5080304@zijn-digital.com (view raw or flat)
Thread:
Lists: pgsql-general
Chris Bowlby wrote:
> Hi All, 
> 
>  I am currently running into an issue with a query and would like to get
> some assistance if possible.
> 
>  The PostgreSQL version I am running is 8.0.11 64-Bit, under SuSE Linux
> Enterprise Server 9 SP3
> 
>  I am converting an encoded field (lot_id) into a date field, the 5
> character of every lot_id is always the year and as such I need to
> extract the year using the following function:
> 
>  substring(ilch.lot_id::text, 5, 1)
> 
>  I am not worried about month or day as it is not used in what I need to
> do, which is why I am using '01/01' for my main concatenation:
> 
>  '01/01/0'::text || ...
> 

You're going to have another problem in about 22 months.

b

In response to

Responses

pgsql-general by date

Next:From: Colin WetherbeeDate: 2008-02-29 18:12:25
Subject: Re: issue with an assembled date field
Previous:From: Bryan MurphyDate: 2008-02-29 17:29:29
Subject: Schema Export/Import

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