Skip to content

Latest commit

 

History

History
56 lines (44 loc) · 1.36 KB

README.md

File metadata and controls

56 lines (44 loc) · 1.36 KB
Raw

Jalali Utils (A Jalali extension for PostgreSQL)

Jalali Utils is a package for converting Gregorian dates to Jalali. This package consists of the following functions:

format_jalali(TIMESTAMP WITH TIME ZONE, with_time BOOLEAN DEFAULT TRUE)
format_jalali(DATE)
jalali_part(TEXT, TIMESTAMP WITH TIME ZONE)
jalali_part(TEXT, DATE)

Examples:

SELECT format_jalali(now()); -->   1399/07/08 23:45:37
SELECT format_jalali(now(), false); -->   1399/07/08
SELECT format_jalali('2019-07-07', false); -->  1398/04/16
SELECT format_jalali('2021-03-20'); -->  1399/12/30 00:00:00
SELECT format_jalali('2021-03-20'::date); -->  1399/12/30
SELECT jalali_part('year', '2019-07-07 14:10:52.84937+04:30'); --> 1398
SELECT jalali_part('minute', '2019-07-07 14:10:52.84937+04:30'); --> 10
SELECT jalali_part('doy', '2019-07-07 14:10:52.84937+04:30'); --> 109
SELECT jalali_part('dow', '2019-07-07'); --> 4

jalali_part function can accept these values as the first parameter:

  • year
  • month
  • day
  • hour
  • minute
  • second
  • doy (day of year)
  • dow (day of week with index zero as saturday)
  • quarter
  • decade
  • century

Installation

Dependencies:

sudo apt install postgresql-server-dev-12

Run make to build and install

make

sudo make install

Run this command in your psql shell:

\d your_db_name

CREATE EXTENSION jalali_utils;

Running tests

make installcheck