Re: timezone

Angelo,

> So simple!
> thank?s Josh
>
> in my case i do :
>  -- SELECT nome, data FROM aprovados order by nome asc --
>  -- printf ("<tr bgcolor='$bgcolor'><td>%s</td><td>%s</td></tr>
> ",$myrow[nome], $myrow[data]); --
>
> the select goes like this?
>
> -- SELECT nome, data to char (??some_date??, 'DD.MM.YYYY');FROM aprovados
> order by nome asc --

that would be:

SELECT nome, to_char(data, 'DD.MM.YYYY') AS data
FROM aprovados
ORDER BY nome ASC;

--
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology     josh@agliodbs.com
    and data management solutions     (415) 565-7293
   for law firms, small businesses      fax 621-2533
    and non-profit organizations.     San Francisco