pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: David Busby <busby@pnts.com>
To: Lynna Landstreet <lynna@gallery44.org>
To: pgsql-php@postgresql.org
Subject: Re: Getting the year from a date column
Date: Wed, 23 Jul 2003 14:59:01 -0700
Message-ID: <012701c35165$a0b85e90$1100000a@busbydev> (raw)
References: <BB447B42.790%lynna@gallery44.org>

try:
$sql = "select exhibition_name,to_char('YYYY',start_date) as start_date \
        from exhibitions where exhibition_id = '$exhibition_id'";


----- Original Message ----- 
From: "Lynna Landstreet" <lynna@gallery44.org>
To: <pgsql-php@postgresql.org>
Sent: Wednesday, July 23, 2003 14:49
Subject: [PHP] Getting the year from a date column


> I'm having a bit of trouble with one part of the PHP front end of the art
> gallery database I'm working on - specifically, extracting the year from
the
> start date of an exhibition. I'm trying to print a list of exhibitions on
> the artist info pages, with the name, gallery space and year for each one,
> and everything's working except the year part.
>
> Here's what I have. First, near the beginning of the PHP portion of the
> page:
>
>     $exh_query = "SELECT exhibition_name, start_date
>         FROM exhibitions WHERE  exhibition_id = '$exhibition_id'";
>     $exhibition_info = pg_exec($db, $exh_query);
>
> Then further down, where I want the year to appear in the exhibition list:
>
>     $date = getdate (pg_result($exhibition_info, 0, 'start_date'));
>     $year = $date['year'];
>     echo $year;
>
> (The 0 for row is because the way the code is structured, $exhibition_info
> only contains one row.) But I'm not sure if getdate() is the right
function
> to be using. It was the only function I could find in the PHP manual that
> was capable of breaking out the individual components of a date (day,
month,
> year, etc.), but it seems to be ignoring the actual date in the query
> results and returning '1969' for everything.
>
> Any idea what I'm doing wrong? Is there a different function I should be
> using instead for this? BTW, I'm using PHP 4.1 (and PostgreSQL 7.2), thus
> the old-style pg function names (pg_result(), etc.).
>
> Thanks,
>
> Lynna
> -- 
> Resource Centre Database Coordinator
> Gallery 44
> www.gallery44.org
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match




view thread (3+ messages)  latest in thread

Message-ID: <012701c35165$a0b85e90$1100000a@busbydev>
Permalink:  ../012701c35165$a0b85e90$1100000a@busbydev/
Also on:    postgresql.org/message-id/012701c35165$a0b85e90$1100000a@busbydev

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: busby@pnts.com, lynna@gallery44.org
  Subject: Re: Getting the year from a date column
  In-Reply-To: <012701c35165$a0b85e90$1100000a@busbydev>
  References: <BB447B42.790%lynna@gallery44.org> <012701c35165$a0b85e90$1100000a@busbydev>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox