Hi,

>Is it possible to convert to date field into a string with 'yyyy/mm/dd'
>format?
>E.g. select format('yyyy/mm/dd', Edit_Time) from Table

Yes, it is possible but usually not the best idea. The usual aproach is to
format dates client side.

> What function can I use to convert it?

You can build a Stored Procedure or an UDF for that. I'm believe existing
UDFs like rFunc and FreeAdhocUDF may already have something like that.


Regards,
Anderson Farias