Index: openacs-4/packages/acs-datetime/tcl/acs-calendar-2-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-datetime/tcl/acs-calendar-2-procs-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-datetime/tcl/acs-calendar-2-procs-postgresql.xql 25 Mar 2002 15:12:37 -0000 1.1 @@ -0,0 +1,33 @@ + + + + postgresql7.1 + + + +select to_char(to_date(:current_date, 'yyyy-mm-dd'), 'D') +as day_of_the_week, +next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday') +as sunday_of_the_week, +to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'Sunday'),'J') +as sunday_julian, +next_day(to_date(:current_date, 'yyyy-mm-dd'), 'Saturday') +as saturday_of_the_week +from dual + + + + + +select to_char(to_date(:current_date, 'yyyy-mm-dd'), 'Day, DD Month YYYY') +as day_of_the_week, +to_char(to_date(:current_date, 'yyyy-mm-dd')-1, 'yyyy-mm-dd') +as yesterday, +to_char(to_date(:current_date, 'yyyy-mm-dd')+1, 'yyyy-mm-dd') +as tomorrow +from dual + + + + +