SQL TIMESTAMP DEFAULT CURRENT TIMESTAMP: How to remove miliseconds?

Question

Problem: When I print time in my HTML code it shows like this: 2020-05-31 03:29:50.617897

Code: https://i.sstatic.net/HTIXy.png

Question: How to get rid of decimal .617897? Thank you. I'm new to programming.

Answer 1

In Postgres, you can use date_trunc():

select date_trunc('second', current_timestamp)