fornmat a datetime

[plork123]

hi all

can someone tell me how i format a datetime field so it's like this

'Thurday 22 June 2006'

many thanks

 

[feherke]

Hi

select to_char(now(),'Day DD Month YYYY');

http://www.postgresql.org/docs/7.3/interactive/functions-formatting.html

Feherke.

http://rootshell.be/~feherke/

 

[plork123]

thanks - why do i get a massive gap between the month and year?

"Thursday 22 June 2006

 

[feherke]

Hi

Because [tt]Month[/tt] is padded. Suppress the extra spaces.

select to_char(now(),'Day DD [red]FM[/red]Month YYYY');

Feherke.

http://rootshell.be/~feherke/

 

[plork123]

i'll do it like this, but would be interested to know why there's a gap

SELECT
TO_CHAR(now(), 'Day') || ' ' ||
DATE_PART('DAY', now()) || ' ' ||
RTRIM(TO_CHAR(now(), 'Month'))|| ' ' ||
DATE_PART('YEAR', now()) AS date