File: select_datetime_functions.sql

package info (click to toggle)
sqlfluff 3.5.0-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 34,000 kB
  • sloc: python: 106,131; sql: 34,188; makefile: 52; sh: 8
file content (13 lines) | stat: -rw-r--r-- 343 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
SELECT current_date;

SELECT sysdate;

SELECT current_timestamp;

SELECT TRUNC(sysdate);

-- As taken from: https://docs.aws.amazon.com/redshift/latest/dg/r_SYSDATE.html
SELECT salesid, pricepaid, TRUNC(saletime) AS saletime, TRUNC(sysdate) AS now
FROM sales
WHERE saletime BETWEEN TRUNC(sysdate)-120 AND TRUNC(sysdate)
ORDER BY saletime ASC;