I am using postgresql. There is a timestamp type column and an id column.
I want to extract it like this.
select date, count(distinct(id)) from table group by date
How do I get the date when I want to use query like?
postgresql
It's a self-answer.
column_name::timestamp::date
That's how it works. Instead of columnn_name, you can put the column name in the timestamp format.
600 GDB gets version error when attempting to debug with the Presense SDK (IDE)
890 When building Fast API+Uvicorn environment with PyInstaller, console=False results in an error
568 rails db:create error: Could not find mysql2-0.5.4 in any of the sources
610 Uncaught (inpromise) Error on Electron: An object could not be cloned
© 2024 OneMinuteCode. All rights reserved.