Re: datetime(): Where is it in the docs?

Henshall, Stuart - WCP wrote:
>
> datetime(x) casts x to type datetime.
> I think use of the datetime type is discouraged and timestamp encouraged.

Ok, so what is the encouraged and hopefully fast/efficient way of doing:

to_char(datetime(a_timestamp), 'MM-DD')

would it be to_char('a_timestamp'::timestamp, 'MM-DD') ?

Basically all I want to do is extract the month and day from a
timestamp. I'd used the EXTRACT functions but you can only extract one
part at a time ...

Jc