The following SQL statement: SELECT TD_YEAR_BEGIN(TIMESTAMP'2012-01-15 12:00:00','ISO',NULL); returns 2012-01-02 00:00:00.