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.
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 |