Special Date/Time Values

[JimKnicely]

Hi,

Vertica has provided several built in time stamp key words for our convenience:

Examples:

Code: Select all

dbadmin=> select timestamp 'today' midnight_today,
dbadmin->        timestamp 'yesterday' midnight_yesterday,
dbadmin->        timestamp 'tomorrow' midnight_tomorrow,
dbadmin->        time 'allballs' midnight_utc_time;
   midnight_today    | midnight_yesterday  |  midnight_tomorrow  | midnight_utc_time
---------------------+---------------------+---------------------+-------------------
 2012-04-11 00:00:00 | 2012-04-10 00:00:00 | 2012-04-12 00:00:00 | 00:00:00
(1 row)

My favorite is ALLBALLS which is named so because the time digits look like balls (I had to Google that).

Thanks

[Josh]

Hmm, my wife calls me NOBALLS all the time. What does that mean!?!?