From: | wr(at)tribe(dot)ping(dot)de |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] extracting date information? |
Date: | 1998-05-19 20:34:31 |
Message-ID: | 19980519223431.25371@tribe.ping.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, May 19, 1998 at 01:27:02PM -0500, Jackson, DeJuan wrote:
> > Now that my dates are being retreived in this format:
> > Sat Dec 12 00:00:00 1998 CET
> >
> > Is there a way to format this to leave off the "time" portion and
> > maybe
> > the "timezone" info ?
> >
> Since you're using php why don't you try (with you date datatype):
> $date = '1998-05-05';
> list($year, $mon, $day) = explode('-', $date);
> echo $date('l M d, Y', mktime(0,0,0,$mon, $day, $year));
I have a similar problem which could be solved if i knew a possibility to
convert datetime values to date values. There is only a function provided
for the opposite direction.
Werner
--
Werner Reisberger public-key available: voice: +49 234 540294
Schoellmannstr. 20 pgp-public-keys(at)keys(dot)pgp(dot)net Fax: +49 234 540239
D-44807 Bochum with "get 0xED527449" in the subject
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Schaffner | 1998-05-19 20:55:20 | Re: [PHP3] RE: [GENERAL] User Authentication Failed |
Previous Message | Jackson, DeJuan | 1998-05-19 19:37:26 | RE: [GENERAL] User Authentication Failed |