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(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco