[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