Postgres create timestamp ( current date + specific time ) format

Viewed 2619

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.

1 Answers
Related