rc.199011 wrote:

> My problem is not on data modelling, but on user receiving emails with long texts concerning company information. For instance, receiving a sentece like this "You product is available since 2004-11-08 14:45:55.0000. Please, call us back as soon as possible." Brazilian people expect to read date information in the format "dd/mm/yyyy".
>
> I use triggers and stored procedures to store this kind of long-text information on special external tables that are translated to XML and used from an external tool to send email and SMS to customers and suppliers.
>
> My problem now is that my triggers and SPs are getting too much long and difficult to understand because of the amount of date and time information that I have to transform in readable text.
>
> That's why I am questioning whether would be another easier solution to format date information in selects, maybe something simple such as Delphi's FormatDateTime function.
>
> Thanks,
>
> Roberto Carlos
>

I am the kind of guy that thinks that data formatting should be done by
client application.

But, as long as you want it done on the server, I suggest you to use an
UDF to format it, if I recall correct rFunc has a FormatDate function.

see you !


--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br