Datetime¶extract date from timestamp¶cast(timeending - interval '30 minutes' as date) as date_updated extract year/month etc from date/timestamp¶extract(part from date) # year, month, day, hour, minute, second extract(year from timeending - interval '30 minutes') as year