pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tubagus Nizomi <nizomi@dnet.net.id>
To: pgsql-sql@postgresql.org
Subject: Re: Date format
Date: Thu, 11 Apr 2002 14:20:06 +0700
Message-ID: <001d01c1e129$4e65fce0$290194ca@dnet.net.id> (raw)
References: <023001c1e127$282e9480$7201a8c0@dmhi.ct.ro>

you can try

psql>SET DATESTYLE TO ISO/SQL/Postgres

ISO          yyyy-mm-dd
SQL         mm/dd/yyyy
Postgres  Wed Dec 17 07:37:16 1997 

Nizomi
  ----- Original Message ----- 
  From: cristi69 
  To: pgsql-sql@postgresql.org 
  Sent: Thursday, April 11, 2002 2:04 PM
  Subject: [SQL] Date format


  Hi,

  I try to set up PG7.1.3 
  The date format now is yyyy-mm-dd 
  How can I start it in date format mm-dd-yyyy?

  in posgresql file  I have: 
  .......-p /usr/bin/postmaster start -o -i > dev/null 2>...........
   
  Thanks in advance!

view thread (13+ messages)  latest in thread

Message-ID: <001d01c1e129$4e65fce0$290194ca@dnet.net.id>
Permalink:  ../001d01c1e129$4e65fce0$290194ca@dnet.net.id/
Also on:    postgresql.org/message-id/001d01c1e129$4e65fce0$290194ca@dnet.net.id

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: nizomi@dnet.net.id
  Subject: Re: Date format
  In-Reply-To: <001d01c1e129$4e65fce0$290194ca@dnet.net.id>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox