Hello again,

> 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
--
Thanks for your help. I need that function in the database for formatting the date in an transfer table to an host-system.



Best regards.

Olaf

--







[Non-text portions of this message have been removed]