date_trunc ( ' microseconds milliseconds second minute hour day week month quarter year decade century millenium ' , val )