Postgres create timestamp ( current date + specific time ) format

Question

I'd love to have timestamp which composed of <[current date] + [specific time I can specify as a string]>.

Ex. 2016-03-08 23:59:59

2016-03-08 => current date
23:59:59 => I can specify

I'd love to do something like

cast(cast( now()::timestamp(0) AS string) || '23:59:59' ) AS timestamp )

in more postgres way.

kaisquared · Accepted Answer · 2016-03-09 10:47:53Z

11

Maybe try:

CURRENT_DATE + TIME '23:59:59'

I don't have access to a database atm so I can't test it out for you but I find Table 9-27 in the link below to be very useful (I find that whole webpage to be very useful).

http://www.postgresql.org/docs/9.1/static/functions-datetime.html

edited Mar 9, 2016 at 10:47

answered Mar 9, 2016 at 10:45

kaisquared

4265 silver badges11 bronze badges

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

2 Comments

Egor Rogov Over a year ago

Almost right. CURRENT_DATE + TIME '23:59:59' (without date).

kaisquared Over a year ago

Just tested it out on my local server. You are absolutely right Egor. Edited my answer to take into account your correction.

Collectives™ on Stack Overflow

Postgres create timestamp ( current date + specific time ) format

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related