date_part with composite fields in PostgreSQL

Question

Is it possible to use the date_part function to extract a composite of multiple specifiers?

For example, I'd like to extract the month, day of month, and hour of day from a timestamp in the single string form "month:day-of-month:hour-of-day" so that

`SELECT date_part('day', TIMESTAMP '2001-02-16 20:38:40');`

would return "02:16:20"

Gordon Linoff · Accepted Answer · 2016-04-27 01:45:27Z

1

This is much easier with to_char():

select to_char(TIMESTAMP '2001-02-16 20:38:40', 'MM:DD:HH24')

The documentation describes the formatting options.

answered Apr 27, 2016 at 1:45

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

date_part with composite fields in PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related