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.
In response to
pgsql-general by date
|Next:||From: Colin Wetherbee||Date: 2008-02-29 18:12:25|
|Subject: Re: issue with an assembled date field|
|Previous:||From: Bryan Murphy||Date: 2008-02-29 17:29:29|
|Subject: Schema Export/Import|