Thomas Markus, 27.11.2009 09:41:
Hi,
not all to zero : "that are less significant than the selected one set
to zero (or one, for day and month)"
Sorry, I missed the "or one" part.
see
http://www.postgresql.org/docs/8.1/static/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT
dow: "The day of the week (0 - 6; Sunday is 0)"
So essentially it *is* always returning Monday independently of any setting.
Thanks for your help
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
