[Babase] Date formats

Karl O. Pinc kop at meme.com
Sat Mar 17 12:52:11 EDT 2007


FYI,

The default date format for postgresql input should
be european format, so if you write '08/01/07'
that should mean Jan 8, 2007, not Aug 1, 2007.

A number of input formats are accepted, the output
formats must be tweaked by wrapping the output
in an approprate formatting function if you
want something besides the default.

See:
http://www.postgresql.org/docs/8.1/static/datatype-datetime.html#DATATYPE-DATETIME-DATE-TABLE
http://www.postgresql.org/docs/8.1/static/functions-formatting.html#FUNCTIONS-FORMATTING-EXAMPLES-TABLE



Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list