Skip site navigation (1) Skip section navigation (2)

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:23:25
Message-ID: 7875.62.220.101.165.1096464205.squirrel@ce.sharif.edu (view raw or flat)
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.

pgsql-patches by date

Next:From: eetemadiDate: 2004-09-29 13:29:49
Subject: Calendars support in postgresql
Previous:From: Magnus HaganderDate: 2004-09-29 11:19:03
Subject: Re: plpython win32

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group