Thread

1. extracting date information?

   Kevin Heflin <kheflin@shreve.net> — 1998-05-19T02:54:23Z

   Any hints or clues on this one?
   Using Postgresql6.3 and PHP2
   
   I have a simple database with a list of events, one of the fields is of
   the data type "date".
   
   When I call this information from the database, it prints out the date
   in the form of "1998-05-05"
   
   What I would really like to do, when this date is retrieved, Is to
   format it something like "Thursday May 5, 1998" Anything more
   descriptive than "1998-05-05" would be great.
   
   I've tried using the "date(format,date)" call from PHP by saving the
   date in a variable, then:
   echo date("YMdl","$thedate");
   
   But when it is displayed it always prints out this date:
   "1969Dec31Wednesday"
   
   Any suggestions or comments would be appreciated.
   
   Kevin
   
   -- 
   ------------------------------------------------------------------
   Kevin Heflin       | ShreveNet, Inc.      | Ph:318.222.2638 x103
   VP/Mac Tech        | 333 Texas St #619    | FAX:318.221.6612
   kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net
   ------------------------------------------------------------------
   
   

2. Re: [GENERAL] extracting date information?

   jose' soares <sferac@bo.nettuno.it> — 1998-05-19T09:58:48Z

   On Mon, 18 May 1998, Kevin Heflin wrote:
   
   > Any hints or clues on this one?
   > Using Postgresql6.3 and PHP2
   > 
   > I have a simple database with a list of events, one of the fields is of
   > the data type "date".
   > 
   > When I call this information from the database, it prints out the date
   > in the form of "1998-05-05"
   > 
   > What I would really like to do, when this date is retrieved, Is to
   > format it something like "Thursday May 5, 1998" Anything more
   > descriptive than "1998-05-05" would be great.
   > 
   > I've tried using the "date(format,date)" call from PHP by saving the
   > date in a variable, then:
   > echo date("YMdl","$thedate");
   > 
   > But when it is displayed it always prints out this date:
   > "1969Dec31Wednesday"
   > 
   > Any suggestions or comments would be appreciated.
   > 
   If you use "datetime" type instead of "date" and set datestyle = 'Postgres'
   your data will be like: Sat Dec 12 00:00:00 1998 CET
   instead of: 1998-12-12
                                                Jose'
   
   
   

3. Re: [GENERAL] extracting date information?

   Kevin Heflin <kheflin@shreve.net> — 1998-05-19T14:09:52Z

   On Tue, 19 May 1998, Jose' Soares Da Silva wrote:
   
   > If you use "datetime" type instead of "date" and set datestyle = 'Postgres'
   > your data will be like: Sat Dec 12 00:00:00 1998 CET
   > instead of: 1998-12-12
   
   I actually stumbled across this after my initial post.
   
   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 ?
   
   
   
   
   --------------------------------------------------------------------
   Kevin Heflin          | ShreveNet, Inc.      | Ph:318.222.2638 x103
   VP/Mac Tech           | 333 Texas St #619    | FAX:318.221.6612
   kheflin@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
   --------------------------------------------------------------------
   
   
   

4. Re: [GENERAL] extracting date information?

   jose' soares <sferac@bo.nettuno.it> — 1998-05-19T17:30:14Z

   On Tue, 19 May 1998, Kevin Heflin wrote:
   
   > On Tue, 19 May 1998, Jose' Soares Da Silva wrote:
   > 
   > > If you use "datetime" type instead of "date" and set datestyle = 'Postgres'
   > > your data will be like: Sat Dec 12 00:00:00 1998 CET
   > > instead of: 1998-12-12
   > 
   > I actually stumbled across this after my initial post.
   > 
   > 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 ?
   
   try this:
   
   prova=> select c from a;
   mydate
   ----------------------------
   Sat Dec 12 00:00:00 1998 CET
   (1 row)
   
   prova=> select  substring(cast(c as text) from 1 for 10)||substring(cast(c as
   text) from 20 for 5) from a;
   ?column?
   ---------------
   Sat Dec 12 1998
   (1 row)
   
   You may also create a function like this:
   
   prova=> create function mydate(datetime) returns text
   prova-> as 'select  substring(cast($1 as text) from 1 for
   10)||substring(cast($1 as text) from 20 for 5) from a;' language 'sql';
   CREATE
   prova=> select mydate(c) from a;
   mydate
   ---------------
   Sat Dec 12 1998
   (1 row)
                                              Jose'