charles
Reputation: 219
Get part of current_timestamp in PostgreSQL
When I do
select CURRENT_TIMESTAMP
I get 2021-02-02 13:58:44.
I want take only this part: 13:58:44 and store it in a variable.
Upvotes: 0
Views: 33
Answers (1)
S-Man
Reputation: 23686
You can cast a timestamp into type time:
SELECT CURRENT_TIMESTAMP::time
Or you can localtime directly.
Upvotes: 2
Related Questions
- CURRENT_TIMESTAMP in milliseconds
- How to get the date and time from timestamp in PostgreSQL select query?
- PostgreSQL CURRENT_TIMESTAMP not showing the correct time
- getting date from timestamp in PostgreSQL
- subtract current_time from timestamp in PostgreSQL
- From Now() to Current_timestamp in Postgresql
- working with a timestamp in postgress
- How to write a postgresql query for getting only the date part of timestamp field, from a table
- PostgreSQL timestamp select
- Postgres TIMESTAMP query