![]() |
ALTER Web ERP - Sistema Informativo Oasi Boschetto |
![]() |
|
|
Torna alle ROOMS
Calendari:
Error in include template "/var/lib/ns/boschetto-dev/packages/calendar/www/view-week-display": Database operation "0or1row" failed (exception ERROR, "ERROR: date/time field value out of range: "1500-02-29"
LINE 12: cast('1500-02-29'::timestamptz - cast('7 days' as interval) ...
^
")
ERROR: date/time field value out of range: "1500-02-29"
LINE 12: cast('1500-02-29'::timestamptz - cast('7 days' as interval) ...
^
SQL:
select to_char(to_date('1500-02-29', 'YYYY-MM-DD'), 'D')
as day_of_the_week,
cast(next_day(to_date('1500-02-29', 'YYYY-MM-DD') - cast('7 days' as interval), 'Monday') as date)
as first_weekday_date,
to_char(next_day(to_date('1500-02-29', 'YYYY-MM-DD') - cast('7 days' as interval), 'Monday'),'J')
as first_weekday_julian,
cast(next_day(to_date('1500-02-29', 'YYYY-MM-DD') - cast('7 days' as interval), 'Monday') + cast('6 days' as interval) as date)
as last_weekday_date,
to_char(next_day(to_date('1500-02-29', 'YYYY-MM-DD') - cast('7 days' as interval), 'Monday') + cast('6 days' as interval),'J')
as last_weekday_julian,
cast('1500-02-29'::timestamptz - cast('7 days' as interval) as date) as last_week,
to_char('1500-02-29'::timestamptz - cast('7 days' as interval), 'Month DD, YYYY') as last_week_pretty,
cast('1500-02-29'::timestamptz + cast('7 days' as interval) as date) as next_week,
to_char('1500-02-29'::timestamptz + cast('7 days' as interval), 'Month DD, YYYY') as next_week_pretty
from dual
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||