root/sql/sprocs/noit.date_hour.sql
| Revision 4bd7d843175692be84818c389d9938e7590cd487, 246 bytes (checked in by Theo Schlossnagle <jesus@omniti.com>, 4 years ago) | |
|---|---|
| |
| Line | |
|---|---|
| 1 | -- Name: noit.date_hour(timestamp with time zone); Type: FUNCTION; Schema: noit; |
| 2 | |
| 3 | CREATE FUNCTION noit.date_hour(timestamp with time zone) RETURNS timestamp with time zone |
| 4 | AS $_$ |
| 5 | SELECT date_trunc('hour',$1); |
| 6 | $_$ |
| 7 | LANGUAGE sql IMMUTABLE STRICT; |
| 8 |
Note: See TracBrowser for help on using the browser.