Calendars support in postgresql

From: eetemadi(at)ce(dot)sharif(dot)edu
To: pgsql-patches(at)postgresql(dot)org
Subject: Calendars support in postgresql
Date: 2004-09-29 13:29:49
Message-ID: 8509.62.220.101.165.1096464589.squirrel@ce.sharif.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

You know that many calendars exist in the world such as Japanese, Indian,
Hebrew, Persian(jalali), ... and no support of these calendars are
supported in postgresql.

The only calendar that is supported in postgresql, is "Gregorian". there
is no support in glibc for calendars in localization support and they
don't have any plan for implementing it.

I wrote tow conversion function for converting between Gregorian and
Persian calendar dates:
gregorian2jalali(gregorian) and jalali2gregorian(jalali)

It is very useful for applications, so they insert date in the tables in
their calendar using this function and select the date in their calendar
using it.

This is useful, writing a function that convert between all calendars. I
am working on this function for some calendars.

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2004-09-29 14:54:03 new target for contrib/Makefile
Previous Message eetemadi 2004-09-29 13:23:25 Calendars support in postgresql