[postgis-users] date/time format

[Linnet Kwamboka]

hey, thanks so much that really helped now i have the normal DMY format,
cheers

On Sun, Mar 14, 2010 at 3:54 PM, Mike Toews <mwtoews at gmail.com> wrote:

> 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
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
With regards,
Linnet Kwamboka

+254733229041
site: geekmates.ning.com
blog: one-kenya.blogspot.com
facebook: mckenzie quamboka
skype: geekmate
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100315/160dd92e/attachment.html>