[postgis-users] date/time format

[Mike Toews]

It depends on your database settings. You can see what it is from
either psql or PgAdmin:

show DateStyle;

(Mine shows "ISO, DMY")

If you want to temporary change it for an SQL session, try:

set DateStyle=SQL, DMY;
select current_timestamp;

And if you like it and want to make a global change for the database:

ALTER DATABASE mydb SET DateStyle=SQL, DMY;

More info:
http://www.postgresql.org/docs/current/static/datatype-datetime.html#DATATYPE-DATETIME-OUTPUT

-Mike

On 14 March 2010 10:27, Linnet Kwamboka <scientific1quash at gmail.com> wrote:
>
> hey guys,
>  when making a table column with date, the date type is chosen, what is the
>    exact date format that can be input? is it DMY or YMD and how can i change
>    this format to be DMY for ease of use?thanks
>
> --
> With regards,
> Linnet Kwamboka
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>