File: ex65.sql

package info (click to toggle)
pgformatter 5.9-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 7,964 kB
  • sloc: sql: 186,493; perl: 5,694; makefile: 2; sh: 1
file content (12 lines) | stat: -rw-r--r-- 316 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
 
SELECT
    date_trunc('month', 日期) FROM ti;

SELECT
    CASE WHEN test = 1 THEN
        (test_table.end_date - ('1 month'::interval) - '1 day'::interval)
    ELSE
        (test_table.end_date - (test_table.number_days * '1 day'::interval) - '1 day'::interval)::date
    END test_start_date
FROM
    test_table;