> for date formating 'dd-mm-yy hh'
> if field name is: dt
>
> LPAD(EXTRACT(day from dt), 2, 0) || '-' ||
> LPAD(EXTRACT(month from dt), 2, '0') || '-' ||
> RIGHT(EXTRACT(YEAR FROM dt), 2) || ' ' ||
> LPAD(EXTRACT(hour from dt), 2, '0')
>
>
> Karol Bieniaszewski

Hi Karol, could you strip out unnecessary quoted text in the future, it contained a few hundred lines of repeated Yahoo Groups administrative info.

BTW: In my opinion, this kind of date formatting should be done at the clientside, not in the database.

Mark
--
NEU: FreePhone - kostenlos mobil telefonieren!
Jetzt informieren: http://www.gmx.net/de/go/freephone