datetime(): Where is it in the docs?
I find myself using the datetime() function a lot (as in
to_char(datetime(x), 'MM-DD')) but to be honest I don't really know what
it does.
I've looked in the online interactive docs but can't find a description
of it anywhere, just an example.
Can someone point me to a definition of the function?
Thanks!
Jc
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
Import Notes
Reference msg id not found: E2870D8CE1CCD311BAF50008C71EDE8E0506DC1B@MAIL_EXCHANGE | Resolved by subject fallback