Skip to content

Commit b866d2e

Browse files
bmomjianbmomjian
committed
as attache of this mail is patch (to the main tree) with to_char's
family functions. Contain: conversion from a datetype to formatted text: to_char( datetime, text) to_char( timestamp, text) to_char( int4, text) to_char( int8, text) to_char( float4, text) to_char( float8, text) to_char( numeric, text) vice versa: to_date ( text, text) to_datetime ( text, text) to_timestamp ( text, text) to_number ( text, text) (convert to numeric) PostgreSQL to_char is very compatible with Oracle's to_char(), but not total exactly (now). Small differentions are in number formating. It will fix in next to_char() version. ! If will this patch aplly to the main tree, must be delete the current to_char version in contrib (directory "dateformat" and note in contrib's README), this patch not erase it (sorry Bruce). The patch patching files: doc/src/sgml/func.sgml ^^^^^^^^ Hmm, I'm not sure if my English... :( Check it anyone (volunteer)? Thomas, it is right? SGML is not my primary lang and compile the current PG docs tree is very happy job (hard variables setting in docs/sgml/Makefile --> HSTYLE= /home/users/t/thomas/.... :-) What add any definition to global configure.in and set Makefiles in docs tree via ./configure? src/backend/utils/adt/Makefile src/backend/utils/adt/formatting.c src/include/catalog/pg_proc.h src/include/utils/formatting.h Karel Zak <zakkr@zf.jcu.cz> http://home.zf.jcu.cz/~zakkr/
1 parent 90aaad0 commit b866d2e

File tree

15 files changed

+3756
-1877
lines changed

15 files changed

+3756
-1877
lines changed

‎contrib/README

Lines changed: 0 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -14,10 +14,6 @@ bit -
1414
Bit type
1515
by Adriaan Joubert <a.joubert@albourne.com>
1616

17-
dateformat -
18-
Date Formatting to/from character strings
19-
by Karel Zak - Zakkr <zakkr@zf.jcu.cz>
20-
2117
datetime -
2218
Date & time functions
2319
by Massimo Dal Zotto <dz@cs.unitn.it>

‎contrib/dateformat/Makefile

Lines changed: 0 additions & 71 deletions
This file was deleted.

‎contrib/dateformat/test/Makefile

Lines changed: 0 additions & 25 deletions
This file was deleted.

‎contrib/dateformat/test/README

Lines changed: 0 additions & 33 deletions
This file was deleted.

‎contrib/dateformat/test/rand_datetime.c

Lines changed: 0 additions & 71 deletions
This file was deleted.

‎contrib/dateformat/test/regress.sql

Lines changed: 0 additions & 58 deletions
This file was deleted.

0 commit comments

Comments
 (0)