-- john r pierce 37N 122W somewhere on the middle of the left coast
Yes, I see this function but if I need to select 100 000 rows this mean I think, this function will be start 100 000 times. I mean when I ask the question, it's is possible to format the date how I like it without to use functions, just something like: set datestyle ('postgres with my custom format 00:00:00 dmy', DMY) something like that. Sry that I did not explain it.
If you cannot use datestyle, then there are no any other possibility. Postgres doesn't support custom datestyles.