你即將離開本站

並前往https://popsql.com/learn-sql/postgresql/how-to-query-date-and-time-in-postgresql

How to Query Date and Time in PostgreSQL - PopSQL

returns 0-6 (integer), where 0 is Sunday and 6 is Saturday select date_part('dow', now()); -- returns a string like monday, tuesday, ...

確定！ 回上一頁

查詢 「PostgreSQL date_part」的人也找了：

  1. PostgreSQL month FROM date
    2.
  2. PostgreSQL date_trunc
    3.
  3. PostgreSQL week
    4.
  4. PostgreSQL weekday
    5.
  5. PostgreSQL date format
    6.
  6. PostgreSQL datediff
    7.
  7. PostgreSQL today
    8.
  8. PostgreSQL now format
    9.