Quarter of year (1, 2, 3, 4 JAN-MAR = 1). A value for SET DATESTYLE can be one from the first list (output styles), or one from the second list (substyles), or one from each separated by a comma. NonEuropean US Use mm/dd/yyyy for numeric date representations. The output format of the date/time types can be set to one of the four styles ISO 8601, SQL (Ingres), traditional POSTGRES (Unix date format), or German. It can be one of the following and can be used in many combinations. European Use dd/mm/yyyy for numeric date representations. The format that will be used to convert string1 to a date. (This works on a per database basis, for a solution for all of your databases, set this parameter in you nf thanks to ahorsewithnoname.) Please be aware that the default setting is not locale independent.

The syntax for the to_date function in PostgreSQL is: to_date( string1, format_mask ) Parameters or Arguments string1 The string that will be converted to a date. Hi, > You need v6.4.2-feature-patch which implement LIMIT option: Or alternatively if you cant or dont want to apply a patch, have a look at the SET QUERYLIMIT TO x in Postgres 6. ALTER DATABASE databasename SET datestyle TO 'ISO, MDY' Try that.

Postgres set to datestyle iso mdyc