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