At 18:14 +0300 on 13/08/1999, Darren Greer wrote:
> Is there a way to change the datestyle for a single select statement. I
> dont wnat to play around with PGDATESTYLE, for fear of messing with other
> program we have using the database, and am not sure if set datestyle sets
> the style for every database, or just the current database.
>
> So, I am wondering if there is a way in which I can specify in the select
> statement to retrieve the date as "SQL" (WHich I believe includes the time).
The SQL command 'SET DATESTYLE' works only for the current session. It
doesn't affect other connections to the database, whether the same database
or another one.
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
