Veeam agent backup network shareJan 01, 2017 · To extract the day of week and or day of year from a time stamp, you use the following statement: SELECT date_part( 'dow' , TIMESTAMP '2017-03-18 10:20:30' ) dow, date_part( 'doy' , TIMESTAMP '2017-03-18 10:20:30' ) doy; dow | doy -----+----- 6 | 77 (1 row) Diablo 3 server status 2021Feb 25, 2012 · select ((date_trunc('week',current_date)::date) + (i+6)) as week_date from generate_Series(0,6) i; Is there a way to get the result as Monday, Tuesday and so on. sql postgresql