SELECT DAY( <TIMESTAMP_FIELD> ) AS DAY, MONTH( <TIMESTAMP_FIELD> ) AS MONTH, YEAR( <TIMESTAMP_FIELD> ) AS YEAR, HOUR( <TIMESTAMP_FIELD> ) AS HOURFROM <TABLE>
